Article ID: 186261
Article Last Modified on 1/23/2007
APPLIES TO
- Microsoft Office 97 Standard Edition
- Microsoft Excel 97 Standard Edition
- Microsoft Word 97 Standard Edition
- Microsoft Access 97 Standard Edition
- Microsoft PowerPoint 97 Standard Edition
- Microsoft Office 97 Service Pack 1
This article was previously published under Q186261
SYMPTOMS
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).
CAUSE
This problem occurs if you do the following:
- On the File menu, you click Properties or Database Properties.
- You click the Custom tab.
- In the Name list box, you select a field name or enter a new field name in the edit box.
- In the Type list, you click Date.
- In the Value box, you enter a date that uses a two-digit year, for example, 7/5/00.
- You click Add.
Note that the date appears in the Properties list box as 7/5/1900, not 7/5/2000.
RESOLUTION
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:
151261 OFF97: How to Obtain and Install MS Office 97 SR-2
STATUS
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).
MORE INFORMATION
For more information about how programs work with two-digit years in dates, please see the following article in the Microsoft Knowledge Base:
302768 How Microsoft Excel works with two-digit year numbers
Additional query words: OFF97 XL97 WD97 AC97 PP97 year2000 y2k 20th century sr1 sr2
Keywords: kbbug kbbug kbfix KB186261