WD: Dates in Table Sort Incorrectly as Date Type

ID: Q140181

The information in this article applies to:

Microsoft Word for Windows, versions 6.0, 6.0a, 6.0c
Microsoft Word for the Macintosh, versions 6.0, 6.0.1, 6.0.1a
Microsoft Word for Windows NT, version 6.0
Microsoft Word for Windows 95, versions 7.0, 7.0a
Microsoft Word 98 Macintosh Edition

SYMPTOMS

Dates earlier than January 1, 1901, or later than December 31, 2035, are sorted incorrectly when you sort a list in a table as a Date type. (To locate this option, click Sort Text on the Table menu.)

For example, when you sort this list:


   May 1, 1504
   Jan 1, 1901
   April 2, 1400
   May 5, 1503
   Sept 6, 1966

The result appears like this:


   May 1, 1504
   April 2, 1400
   May 5, 1503
   Jan 1, 1901
   Sept 6, 1966

CAUSE

Word does not recognize dates earlier than January 1, 1901, or later than December 31, 2035, as valid dates.

WORKAROUND

Sort the dates as text.

Additional query words:


Keywords          : kbualink97 kbdta wordnt macword98 winword ntword macword kbtable word6 word7 word95 
Version           : MACINTOSH:6.0,6.0.1,6.0.1a,98; WINDOWS:6.0,6.0a,6.0c,7.0,7.0a; winnt:6.0
Platform          : MACINTOSH WINDOWS winnt 
Issue type        : kbprb

Last Reviewed: July 8, 1999