Why Date Fields from Excel Import Incorrectly?
I am importing an excel data file to Caspio but the dates are imported incorrectly and are years off the original dates. Why is this happening?
Microsoft Excel supports two date systems, 1900 and 1904. If you are a Mac user, Excel 2008 to 2011 default to 1904 system as opposed to Windows Excel which defaults to 1900. More information can be obtained at http://support.microsoft.com/kb/214330.
Caspio supports the Windows standard date system (1900). Mac users may have to change their date system before importing their file.
To change your date system on the Mac take these steps:
- From Excel menu, click Preferences, and then click Calculation.
- Clear the check box shown below to use the Windows standard system (1900).
If you do not want to change your Excel date system, you can save the excel file as CSV (comma separated value) which is a text format and then import it to your Caspio account. Please remember in this case if you are importing the data file as a new table you need to choose the proper data types for each field, however if you are importing to replace or append an existing table you are fine because the data types are already defined in your table.