Date Format from Number to DD/MM/YYYY

[Faithful]

Hello,

Please help me to change date format from number "44585" to dd/mm/yyyy. In the raw excel file, it was originally dd/mm/yyyy however alteryx changed it to number. 

Please see attached workflow and screenshot.

[DataNath]

Hey @Faithful, is this what you're expecting? ToDate() will bring the numeric representation into ISO format (YYYY-MM-DD, which is all Alteryx can work with). Therefore, we just use DateTimeFormat() to force it into our desired DD/MM/YYYY format. The only thing to note is that we have to keep this stored as a string. If you want to work with dates, you'll have to maintain the ISO date format mentioned above.