Free Trial

General Discussions

Discuss any topics that are not product-specific here.

DATE Format change

Lizbhernan
7 - Meteor

I am trying to change the format of the date on my report (dd-mm-yy e.g. 15-oct-24) to format MM/DD/YYYY. I tried using the DateTime tool but I am getting Null. Can someone please help?

2 REPLIES 2
cmoussa
8 - Asteroid

Try using the attached WF. You need to convert the string date you have to an Alteryx date and then apply the date time format tool

Sanskriti22
5 - Atom

You can alternatively use this formula in workflow = DateTimeFormat(DateTimeParse([DateField], "%d-%b-%y"), "%m/%d/%Y") for achieving desired result 

Labels
Top Solution Authors