Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Alteryx reading excel date wrong

jmarcuzb
7 - Meteor

I am reading dates from an excel spreadsheet. This spreadsheet is storing the dates as numbers. For example the spreadsheet shows 1/3/1900 but underneath it stores it as the number 3.  When I read this with Alteryx it gives me 1/2/1900 instead of 1/3/1900.

I cannot simply add 1 to the date to correct it because it doesn’t  read all the dates wrong, just the year 1900. 

Is there any way to correct this guys?

 

thanks

3 REPLIES 3
jmarcuzb
7 - Meteor

Thanks

182129
7 - Meteor

Is there a new solution for this? The link provided was archived.

Labels
Top Solution Authors