Date fields are not working properly on a Mac. The date field is off by 4 years and 1 day.
The problem relates to an Excel setting that is set by default differently on a MAC vs on a PC. The setting is for Excel to use a January 2nd, 1904 starting date for MACs while PCs use January 1st 1900. That would be why all the dates after upload show the date being 1 day and 4 years off.
To correct this on a MAC, change the setting in Excel to mimic Excel in Windows (since iDashboards uses a Windows based server). On a MAC, uncheck the “Use 1904 system” checkbox found under Options -> Advanced.
For more information follow this link:
- Eval Cloud
- Cloud Standard
- Cloud PAL
- Private Cloud
- X Platform
- Enterprise Suite