OFF97: Two-Digit Years in Properties Dialog in 20th Century

In any of the programs listed at the beginning of this article, if you enter a date that uses a two-digit year in the Custom tab of the Properties dialog box, the date is in the twentieth century (from 1900 to 1999).

This problem occurs if you do the following:

1. On the File menu, you click Properties or Database Properties.
2. You click the Custom tab.
3. In the Name list box, you select a field name or enter a new field name in the edit box.
4. In the Type list, you click Date.
5. In the Value box, you enter a date that uses a two-digit year, for example, 7/5/00.
6. You click Add.

Note that the date appears in the Properties list box as 7/5/1900, not 7/5/2000.

To temporarily work around this problem, use a four-digit year, for example, 7/5/2000.

To correct this problem, obtain Microsoft Office 97 Service Release 2 (SR-2).

For additional information about SR-2, please see the following article in the Microsoft Knowledge Base:

Microsoft has confirmed this to be a problem in the programs included in both Microsoft Office 97 for Windows and Microsoft Office 97 for Windows, Service Release 1 (SR-1). This problem was corrected in Microsoft Office 97 Service Release 2 (SR-2).

For more information about how programs work with two-digit years in dates, please see the following article in the Microsoft Knowledge Base: