OFF97: Date in Office Document Embedded in Lotus Notes Form Changes by 100 Years

ID: Q239908


The information in this article applies to:
  • Microsoft Excel 97 for Windows
  • Microsoft Word 97 for Windows


SYMPTOMS

When you open a Microsoft Excel worksheet or a Microsoft Word document that has been embedded in a Lotus Notes document, one or more dates are changed; 100 years are added to some of the dates in your document.


CAUSE

This problem occurs when the following conditions are true:

  • You have inserted a Microsoft Word document or a Microsoft Excel worksheet in a Lotus Notes form.


  • -and-

  • The Word document or Excel worksheet contains dates earlier than 1950.


  • -and-

  • You have created a custom document property that links to the date(s).


  • -and-

  • The Short date style setting on the Date tab of the Regional Settings icon (in Control Panel) is set to display two digits for year values.


WORKAROUND

To work around the problem, change the Short date style setting on the Date tab of the Regional Settings icon (in Control Panel) to a format that displays four digits for year values.

NOTE: Changing the Short date style setting only prevents this problem from occurring in the future. Changing this setting does not repair any date values that have already been affected by this problem.

For more information about how Lotus Notes interprets dates with two-digit years, point your Web browser to the following address:

http://www.lotus.com/home.nsf/welcome/y2k
The third-party contact information included in this article is provided to help you find the technical support you need. This contact information is subject to change without notice. Microsoft in no way guarantees the accuracy of this third-party contact information.


STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.


MORE INFORMATION

Only dates that are linked using a custom document property are affected by this problem.

The third-party products discussed here are manufactured by vendors independent of Microsoft; we make no warranty, implied or otherwise, regarding these products' performance or reliability.

Additional query words: notesfx fx OFF97 WD97 XL97 y2k year2000 year 2000

Keywords : kb3rdparty kbinterop kbdta kb2000 DTIR kbcl
Version : WINDOWS:97
Platform : WINDOWS
Issue type : kbbug


Last Reviewed: August 31, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.