Date Time Question

[Hayesb]

I used the following to convert a date/time to only the time.  However, it is changing 2:00 pm to 02:00 instead of 14:00.  I have tried researching and see a lot of examples for %H but when I enter that it only returns "%H" in the field.  

Can someone provide an example of how to convert the date/time to a 24 hour time only?

To_char ("shipped_date", 'hh:mm')

Thanks,

Brett

[atcodedog05]

Hi @Hayesb 

You can use something like this

DateTimeParse("01/01/2020 "+[Field1],
'%m/%d/%y %I:%M %p')

Output:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[StephV]

Hi @Hayesb,

Thank you for your question to the Community!

I moved your post to the Designer Discussions forum there you can ask anything technical about Designer. 

If this @atcodedog05's post helps you please mark it as solution.

This article "Q&A: Where Do I Post My Questions?" should also help you out. 

Let us know how it goes!

Cheers,