Shared file 1904 date

[ttiverson98]

I am using a shared file that I cannot make changes to and when I try to add it to Alteryx, I get the 1904 date message.

Is there a way around this?

Thanks,

Todd

[HomesickSurfer · Accepted solution]

Hi @ttiverson98 

The 1904 error is a result of your Excel file method of calculation.

You can modify the Advanced Option as below...

Let me know if it works for you.

[TheOC · Accepted solution]

hey @ttiverson98 

This is a setting when saving the excel spreadsheet:

(within excel)

I would suggest saving a copy of this workbook with this disabled, and see if that helps.

Cheers,
TheOC

[papshind]

Hi , 

My excel file has many date columns. If i uncheck "use 1904 date format" option, then all date Column values are getting changed.

How to resolve this. Or is there any other way in Alteryx to load excel files with "use 1904 date format" option enabled. 

[xavierriotte]

I faced this problem today...

Disabling the 1904 data system option won't solve your problem.

Alteryx will be able to read it but it will change the dates to the 1900 system.

So instead of adding the number of days to 1904-01-01 it will add it to 1900-01-01.

So all your dates will be four years earlier!

The solution I found was the following:

- Ensure the dates are stored in numbers in Excel.

- Input the Excel file as it is.

- Add the following formula tool to get the right date: DateTimeAdd("1904-01-01",[DATE_IN_1904_NUMBER_FORMAT],"days")