Dynamic Input changing date format

[saachitalwar]

I am picking a file using dynamic input and it's reading the date entirely wrong.

I have attached screenshots of the actual input date and the input being read by Alteryx.

Any help identifying the error here and how to resolve it is appreciated.

Thanks!

[alexnajm]

Just convert it after reading it in! It is in Excel numerical date format so lot of articles in the Community can help, like this: Solved: How to convert the Excel numerical date to date in... - Alteryx Community

[binuacs]

@saachitalwar as @alexnajm mentioned you can use the toDate() function to convert the numeric datatype into Date format