Dynamic Input changing date format

Question

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!

Input Date.PNG

Dynamic Input Date.PNG

binu_acs · Answer

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

alexnajm · Answer

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