COnverstion from string to time

Q&A
, ,
1

Hello I have a string in the format HH:mm
however if I try to use the function
parseDate({delivery time},‘HH:mm’) it does not work,
it just gives me error in the function

image
image3731×694 62.7 KB
`
image
image1472×232 12.9 KB

any suggestion?

2

Hello @remba87 Hope this message finds you well.

I got some suggestions to you based on the information that the function parseDate({delivery time}, 'HH:mm') isn’t working

Ensure the {delivery time} field is exactly in the HH:mm format. Any deviation, like extra spaces or unexpected characters, can cause errors.
I suggest to check too if {delivery time} is a string. If not, convert it to a string before using parseDate.
Another point could be related to your environment’s regional settings match the date and time format you’re using.

Please, let me know if it’s work.

3

Hi @remba87 ,

Quick Sight does not have a timestamp data type and it must be throwing error for the same reason.

Can you try something like:
parseDate(concat('1990-01-01 ', {delivery_time}),‘yyyy-MM-dd HH:mm’)

This will tag all time to the date 1990-01-01 and you can later format the field to show only HH:mm and use it likewise.

Thanks,
Prantika

4

Hi @remba87 - Can you please share sample data and expected output. This will help in replicating the issue at our end and advise you accordingly.

You can try suggestions from prantika and lary as well.

Regards - Sanjeeb

5

Hi @remba87,
It’s been awhile since we last heard from you, did you have any additional questions regarding your initial post or were you able to find a work around?

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you!

6

Hi @remba87,
Since we have not heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.

Thank you!