APPENDIX D Microsoft Product Date Limits and Formats

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