Dates imported from MS-Excel are off by 4 years

Navigation:  FAQ > Data >

Dates imported from MS-Excel are off by 4 years

Previous pageReturn to chapter overviewNext page

You can import data from an MS-Excel spreadsheet into Recurring Holidays, One-Time-Dates and Slogans (use the corresponding links for more details). Sometimes, however, if the Excel file was created on the Macintosh, you will find that when you open that spreadsheet under Windows, dates are approximately 4 years off from the values they had on the Macintosh.

 

 

This is due to the setting 1904 date system in the Macintosh version of MS-Excel (see above). Always make sure that your version of Excel has this option un-checked.


Topic 173660 updated on 10-Nov-2002.
Topic URL: http://www.qppstudio.net/webhelp/index.html?datesimportedfromms-excela.htm