OL97: Year 2000 Dates Are Imported and Exported Incorrectly

ID: Q197237

The information in this article applies to:

Microsoft Outlook 97

SYMPTOMS

Using Microsoft Outlook to import or export text files, with dates formatted with two-digit years, results in some years being designated in the wrong century.

NOTE: If you are using Outlook 98, please see the following related article:

Q193604 OL98: Year 2000 Dates Are Imported and Exported Incorrectly

For additional information on Outlook and year 2000 issues, click the article number below to view the article in the Microsoft Knowledge Base:

Q216410 OL97: Printing Outlook 97 Calendar Displays Year as 2099

CAUSE

The Outlook translation files, Transmgr.dll and Rm.dll, do not handle some two-digit dates correctly.

RESOLUTION

Microsoft has made a combined fix available to correct both the import and export issues. This file contains the following files:


   File name      Version
   ------------------------
   Transmgr.dll   1.0.0.102
   Rm.dll         1.0.0.104
   Readme.txt

A Readme file is included with instructions on installing the updated files.

The following file is available for download from the Microsoft Download Center. Click the file name below to download the file:

O97dtfix.exe

Release Date: May 10, 1999

For more information about how to download files from the Microsoft Download Center, please visit the Download Center at the following Web address

http://www.microsoft.com/downloads/search.asp

and then click How to use the Microsoft Download Center.

The international versions of this file are also located on the Download Center.

STATUS

This problem was corrected in Microsoft Outlook 2000.

MORE INFORMATION

Importing Issues

The importing issues have to do with the format of the dates in the incoming import file. For example, an incoming date that is formatted with a two-digit year, such as 7/1/00, is translated to 7/1/1900 instead of 7/1/2000.

Exporting Issues

The exporting issues have to do with the designation of the date range for exportation, for example:

If you enter an export date range using a two-digit year for a valid leap-year, such as 2/29/96 or 2/29/00, Outlook will not recognize the valid leap-year and the OK button in the Set Date Range dialog box will not be available.

If you enter an export date range using a year of "99" such as 1/1/99 through 1/31/99, Outlook will not recognize these as valid dates and the OK button in the Set Date Range dialog box will not be available.

If you enter an export range using a year of "00" such as 1/1/00 through 1/31/00, Outlook will export appointments for the year 1900.

If you enter an export range without entering the year, such as 1/1 through 1/31, Outlook will export appointments for the year 1900.

NOTE: These issues do not occur if you use four-digit years during the import and export process, nor do they occur when entering appointments, contacts, and tasks with Outlook forms.

Date Determination in Outlook

The following describes the intended behavior of the Outlook translation files in converting dates with two-digit years into dates with four-digit years.

The translation files use a range of 100 years to determine into which century the two-digit year should fall. The default range is computed by subtracting 29 from the current year to derive the lower end of the range and adding 70 to the current year for the upper end. If the two-digit year plus 1900 falls within this range, the date should be considered to be in the 1900s. Otherwise the year should be considered to be in the 2000s.

Examples

The translation files use the -29/+70 formula to compute the range as follows:


   Current year: 1998         Current year: 1998
                  -29                        +70
                 ----                       ----
   Lower end:    1969         Upper end:    2068

Assuming these dates, the four-digit year would be derived as follows:


   9/14/00 - Outlook would add 1900 to the year giving 1900.
             1900 does NOT fall within the 100-year range of 1969-2068.
             Therefore, 9/14/00 should be interpreted as 9/14/2000.

   9/14/30 - Outlook would add 1900 to the year giving 1930.
             1930 does NOT fall within the 100-year range of 1969-2068.
             Therefore, 9/14/30 should be interpreted as 9/14/2030.

   9/14/70 - Outlook would add 1900 to the year giving 1970.
             1970 DOES fall within the 100-year range of 1969-2068.
             Therefore, 9/14/70 should be interpreted as 9/14/1970.

   9/14/99 - Outlook would add 1900 to the year giving 1999.
             1999 DOES fall within the 100-year range of 1969-2068.
             Therefore, 9/14/99 should be interpreted as 9/14/1999.

REFERENCES

For more information about how Microsoft products are affected by year 2000 (Y2K) issues, please see the following Microsoft World Wide Web site:

http://www.microsoft.com/year2000/

Additional query words: 97 Y2K Millennium Bug

Keywords : kbfile kbdta kb2000 IntpImEx
Version : WINDOWS:97
Platform : WINDOWS
Issue type : kbbug