Date and Time

Question

02-FEB-22 05.02.58.000000000 PM

Hi All,

Does anyone how to convert above string in a date and time format in AM and PM. I tried this and it works but does not consider AM PM.

DateTimeParse([Field1],'%d-%b-%y %H.%M.%S')

Regards,

Rahul Jain

amruthas2 · Answer

Hi @JAIN2

Alteryx by default trims milli seconds - seems it is stil not implemented

Add DateTime type with milliseconds - Alteryx Community

If milliseconds doesnt impact your calculation much , You can use the below formula,

DateTimeFormat(
ToString(DateTimeParse([Date],'%d-%b-%y %H.%M.%S'))
,'%d-%b-%y %H.%M.%S %p')

Qiu · Answer

@JAIN2 
We need use the Specifier '%p' as below