Date format

[nkr306_nkrs]

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.

[FrederikE]

Hey @nkr306_nkrs,

What do you mean with "once the file is uploaded" - where to?

And what file format are we speaking about? 

[apathetichell]

What do you mean by uploaded? Is this an excel file - and if so is the original column in date format? Can you share some screen grabs?

[nkr306_nkrs]

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

[apathetichell]

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

[apathetichell]

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.