WD2000: Tables with Dates Beyond the Year 2036 Sort Incorrectly (209748)
The information in this article applies to:
This article was previously published under Q209748 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 |
STATUSMicrosoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
| Modification Type: | Major | Last Reviewed: | 11/25/2002 |
|---|
| Keywords: | kbbug KB209748 |
|---|
|