Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Alteryx is here to help you solve your biggest data challenges. Read about the new Virtual Solution Center here.

Date Conversion

Highlighted
5 - Atom

The Date in my Excel is 07/01/2018 with 100 rows of same date and the format in the Excel is in mm/dd/yyyy, but when its being imported to the Alteryx Designer the date column gets converted to 1900-01-06. Any suggestions?

Alteryx Partner

Hello @RaghuPrasad,

 

I just tried to reproduce your issue, but was not successful, would you mind to share an extract of your excel data and your workflow to look at?

 

In my case, I never saw any difficulties with a date conversion on Alteryx' side.

 

Best,

 

Johannes

Highlighted
11 - Bolide

The Excel 'date' is likely a number and when you set the field to be a date in Alteryx it messes it up. See below post for more info. 

 

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-to-convert-the-Excel-numerical-dat...  

Labels