WD2000: Tables with Dates Beyond the Year 2036 Sort Incorrectly

ID: Q209748


The information in this article applies to:


SYMPTOMS

When you sort a table column containing dates that include years beyond the year 2035, the table sorts incorrectly. Specifically, any date beyond February 7, 2036, sorts incorrectly and is interleaved between each date prior to February 7, 2036.

Expected

Result

1/7/1900

1/7/1900

1/7/1901

1/7/2037

1/7/1902

1/7/1901

1/7/1903

1/7/2038

1/7/2035

1/7/1902

1/7/2036

1/7/2039

1/7/2037

1/7/1903

1/7/2038

1/7/2040

1/7/2039

1/7/2035

1/7/2040

1/7/2036


STATUS

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


MORE INFORMATION

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/y2k/

Additional query words:


Keywords          : kbdta wd2000 
Version           : WINDOWS:2000
Platform          : WINDOWS 
Issue type        : kbbug 

Last Reviewed: May 21, 1999