Skip to content

Calculate field - Quicksight

0

I have a date like this '26 jun. 14:06:00', but i need only the time, how i can extrac only the time ?

1 Answer
0

You can combine formatDate and substring to extract the relevant piece of information that you want.

formatDate(date, ['format']) https://docs.aws.amazon.com/quicksight/latest/user/formatDate-function.html

substring(expression, start, length) https://docs.aws.amazon.com/quicksight/latest/user/substring-function.html

If that doesn't work for any reason you can try extract to pull out only hours, minutes, and seconds then concat the fields together or use separate calculated fields.

extract(period, date) https://docs.aws.amazon.com/quicksight/latest/user/extract-function.html

I hope one of these solutions helps you.

EXPERT
answered 3 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.