Microsoft Access Developer Interview Question:

Tell us access is returning incorrect results for the specified years 1900 through 1915?

Submitted by: Muhammad

Access interprets years differently than in prior versions. For example #01/01/15# returns January 1, 1915 in previous versions. Access will return January 1, 2015. Modify your date specification to be #01/01/1915#.
Submitted by: Muhammad