Issue With DateTimeParse

[michaeljones1]

Hi all,

I know I'm not the only one with this issue but could definitely use an assist. Trying to work through a DateTimeParse and it seems to keep erring out.

The original string is as follows: 2019/07/08 7:33:18 PM

Would've thought that this formula would do the charm but I'm getting the error below: DateTimeParse([Created On],"%Y/%m/%d %I:%M:%S %X")

Formula (12) DATETIMEPARSE: Cannot convert "2019/04/01 9:07:50 PM" to a date/time with format "%Y/%m/%d %I:%M:%S %X": Expected a number for hour: 'PM'

Thanks!

Michael

[Thableaus · Accepted solution]

Hi @michaeljones1 

Change %X to %p

DateTimeParse([Created On],"%Y/%m/%d %I:%M:%S %p")

Cheers,

[JosephSerpis · Accepted solution]

Hi @michaeljones1 this syntax should work DateTimeParse([Created On],"%Y/%m/%d %I:%M:%S %p")

[LordNeilLord · Accepted solution]

Hey @michaeljones1 

When you use %X you don't need to specify the H:M:S

DateTimeParse([Field1], "%Y/%m/%d %X")

[michaeljones1]

Thanks everyone!!

[Dazzerman]

Try this formula :

DateTimeParse([Date_string],"%Y/%m/%d %X")