Sign Up for Training |
Jet Global Company Site
Community
Downloads
Training
Submit a Request
Become a Jet Insider
Give Feedback

Dates are four years ahead of expected


Symptom

Your reports are returning dates (i.e. Posting Dates or Period Start dates) four years ahead of the year that you are filtering for.

Cause

you may have your workbook set to use the 1904 date system.

datesystem.png

Resolution

Un-check box next to the "1904 date system" setting.

If you have your Windows Regional Settings configured to treat dates as MM/DD/YYYY and you are using dates in your reports as DD/MM/YYYY, you will either get unexpected results or #VALUE, depending on which dates you are specifying.

You can create the same sort of problem with some database servers that have a built in date formula specification. For some database servers, the date format can be configured independently from Windows, so you need to know what date format the server is set to.

Was this article helpful?
0 out of 1 found this helpful
Have more questions? Submit a request

Comments