Convert to AM/PM

[mhtomines]

Hi Team,

I would like to convert below date:

17 Aug 2022 12:41 PM
17 Aug 2022 02:24 PM
17 Aug 2022 08:23 AM

to desired:

2022-08-17 12:41 PM
2022-08-17 02:24 PM
2022-08-17 08:23 AM

Thank you!

[DataNath]

@mhtomines one way of achieving this with the Formula tool would be to use the following expression:

DateTimeFormat(DateTimeParse([Input],'%d %b %Y %I:%M %p'),'%Y-%m-%d %I:%M %p')

[Qiu]

@mhtomines 
@DataNath gives good sample flow. 
And if we  can try a different tool we can use the DateTime tool as below.

BUt still this page needs to be familaized with.

https://help.alteryx.com/20221/designer/datetime-functions