Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

date

mnhhs
7 - Meteor

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.

4 REPLIES 4
meeravijayan2011
8 - Asteroid

Hi @mnhhs ,

Hope the attached workflow will help you. 

benakesh
12 - Quasar

HI @mnhhs ,

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

benakesh_0-1575261385706.png

 

mnhhs
7 - Meteor

 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
12 - Quasar

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...

 

 

Labels