MARK MAYES
The following table shows Microsoft’s products and the life expectancy of the date formats used within them. Unless otherwise noted, Microsoft’s products rely on the system-supplied date formats.
Product Name | Date Limit | Date Format |
Microsoft Access 95 (assumed date) | 1999 | assumed “yy” dates |
Microsoft Access 95 (explicit date) | 9999 | long dates (“yyyy”) |
Microsoft Access 97 | 2029 | assumed “yy” dates |
Microsoft Excel 95 | 2019 | assumed “yy” dates |
Microsoft Excel 95 | 2078 | long dates |
Microsoft Excel 97 | 2029 | assumed “yy” dates |
Microsoft Excel 97 | 9999 | long dates |
Microsoft Project 95 (and previous versions) | 2049 | 32 bits |
Microsoft SQL Server | 9999 | “datetime” |
Visual C++ (4.x) run-time library | 2036 | 32 bits |
Visual FoxPro | 9999 | long dates |
FAT16 file system | 2108 | 16 bits |
Windows 95 file system (FAT32) | 2108 | 32 bits |
Windows 95 run-time library | 2099 | 16 bits |
Windows NT file system (NTFS) | future centuries | 64 bits |
Windows NT run-time library | 2099 | 16 bits |