Shared file 1904 date
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
- Labels:
- Date Time
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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")
