date

[mnhhs]

Hi, I 'm trying to convert the date 2/09/2019  8:35:00 AM to "dd/mm/yyyy" format with the following formula, "DateTimeParse([Scope In],"%d-%m-%y")". The result is "2019-10-01" which is not in the desired format. Can you pls guide, thanks.

[meeravijayan2011]

Hi @mnhhs ,

Hope the attached workflow will help you. 

[benakesh]

HI @mnhhs ,

Try  this formula  :   DateTimeParse([Scope In],"%d/%m/%y")  .

[mnhhs]

 HI,Thank you for the prompt reponse. How can I also have the output with AM/PM at the end? example "8:25 AM", thank you.

[benakesh · Accepted solution]

Hi @mnhhs ,

Try  DateTimeParse([Scope In],"%d/%m/%y %H:%M:%S") . 

In my example  %I is not working . 

Check this  link for  more details  about  24 hour vs  12 hour time .  %I  and %P  only work for  12 hour time . 

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Date-Time-Parsing-Excel-AM-PM-format/m...