Is there any predefined formula to covert the above date format to MM/DD/YYYY
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
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