The low end of the operational date range for Jet 4.0 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 4.0. 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 greater.
NOTE: The date limits in an Access project are different from those described for a Jet database. Date and time data types for representing the date and time of day in SQL Server 7.0 are:
- datetime -- date and time data from January 1, 1753, to December 31, 9999.
- smalldatetime -- date and time data from January 1, 1900, to June 6, 2079.
SQL Server rejects all values it cannot recognize as dates between 1753 and 9999.