Microsoft KB Archive/239871

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

Article ID: 239871

Article Last Modified on 10/31/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition
 * Microsoft Word 2000 Standard Edition

-



This article was previously published under Q239871





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

Microsoft provides third-party contact information to help you find technical support. This contact information may change without notice. Microsoft does not guarantee the accuracy of this third-party contact information.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are 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 that are discussed in this article are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, regarding the performance or reliability of these products.

Additional query words: OFF2000 notesfx fx WD2000 XL2000 y2k year2000

Keywords: kbbug kbinterop kb3rdparty KB239871

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.