ACC97: Operational Range for Dates in Microsoft Access 97 (240244)
The information in this article applies to:
This article was previously published under Q240244 Moderate: Requires basic macro, coding, and interoperability skills.
SUMMARY
You can store date values in a Microsoft Jet 3.5 database starting with the year 100 and up to the year 9999. However, many database functions support only a limited range of dates. This article describes the operational date range for a Jet 3.5 database.
MORE INFORMATION
The low end of the operational date range for Jet 3.5 is the year 200, and the high end of the operational date range is the year 2038. Although you can enter dates with years outside of this range, some Jet functionality will return incorrect results. Non-native Jet database formats, particularly ODBC sources, may or may not support dates outside of the range of Jet 3.5. When dates outside of the range are not supported, imports and exports may fail, records containing dates outside of the specified range may be deleted, or incorrect results may be returned from queries for dates outside of the specified range.
Also, replication limits the low end of the range to the year 200 in order to correctly calculate retention periods and to provide date stamps for certain system tables when the current year is 2000 or later.
| Modification Type: | Major | Last Reviewed: | 9/26/2003 |
|---|
| Keywords: | kbhowto KB240244 |
|---|
|