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
Solved! Go to 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
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