WD2000: Dates in Table Are Sorted Incorrectly as Date Type (212009)
The information in this article applies to:
This article was previously published under Q212009 SYMPTOMS
Dates earlier than January 1, 1901, or later than December 31, 4095, are sorted incorrectly when you sort a list in a table as a Date type.
CAUSE
This behavior occurs because Microsoft Word does not recognize dates earlier than January 1, 1901, or later than December 31, 4095, as valid dates.
WORKAROUND
To work around this issue, follow these steps:
- Select the dates to be sorted.
- On the Table menu, click Sort.
- In the Sort Text dialog box, under Sort by, click Field 2; in the Type box, click Number.
- In the Sort Text dialog box, under Then by, click Field 1; in the Type box, click Date.
- Click OK.
When you use this method, Word treats the comma as a field separator (any character that separates one field of data from another) and can then sort the list of dates by using the year as a Number field, and by using the month and day as a Date field.
| Modification Type: | Major | Last Reviewed: | 2/7/2001 |
|---|
| Keywords: | kbbug kbtable KB212009 |
|---|
|