Alteryx reading excel date wrong

[jmarcuzb]

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

[binuacs · Accepted solution]

@jmarcuzb The below post will give you an idea

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Convert-excel-numeric-date-to-date-for...

[jmarcuzb]

Thanks

[182129]

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