How to convert the Date "Jan 21,2022" to MM/DD/YYYY?

[garvit1495]

Is there any predefined formula to covert the above date format to MM/DD/YYYY

[ShankerV]

Hi @garvit1495 

This formula will help

datetimeformat(datetimeparse([Field1],"%b %d,%Y"),"%m/%d/%Y")

[binu_acs]

DateTimeFormat(DateTimeParse([Date],'%b %d,%Y'),'%m/%d/%Y')

@garvit1495 One way of doing this

[ShankerV]

Hi @garvit1495 

Important note: You will not be able to save the output in the Date datatype.

Date datatype will accept only ISO dateformat which is YYYY/MM/DD

Hence the output is saved in the String datatype.

Hope this helps!!!!

Please let us know if you have more questions.

Many thanks

Shanker V

[willemb]

This will do it: 

datetimeformat(DateTimeParse([Field1],'%b %d, %Y'),'%m/%d/%Y')

More detail on the formats here: https://help.alteryx.com/20223/designer/datetime-functions