Date format

Question

Hello Everyone I am seeing that the date format of my Input file is changing as soon as I run the work flow. This is a date format in my input file  3/7/2023 and once the file is uploaded the format is changing to 03/07/23. Can someone please advise why is this happening and advise how I can fix this.

apathetichell · Answer

My test of this confirmed my suspicion that Excel opens both 3/7/2023 and 3/07/23 as 3/7/2023 - this is an Excel error. Alteryx is showing you the value of your .csv file. Excel is incorrect.

apathetichell · Answer

Open it in notepad. Examine the underlying value in notepad.

nkr306_nkrs · Answer

It is an Excel CSV format file.

This is the format in the Input file.

and this is the format that is reflecting in Alteryx