WD2000: Tables with Dates Beyond the Year 2036 Sort IncorrectlyID: Q209748
|
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
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.
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