Date and Time

[JAIN2]

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

[Qiu]

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

[amruthas2]

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')