Date format change

[Naga]

Hi Team,

Please help. I need the date format to be changed from  input (excel) to output.

Input date format in excel file - m/d/yyyy (7/1/2019)

Output date format - CCYYMMDD (20190701)

Thanks

Naga

[fmvizcaino · Accepted solution]

Hi @Naga ,

Attached is an example showing how to do it with 2 datetime tools.

Be aware that Alteryx only let yyyy-mm-dd format as a date format, everything else needs to be in string format.

Best,

Fernando Vizcaino

[RolandSchubert · Accepted solution]

Hi @Naga ,

the formula 

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

should return the expected result. DateTimeParse converts the Excel-Format to a date, DateTimeFormat converts it to the format you need)

Best,

Roland