Microsoft KB Archive/140181

= WD: Dates in Table Sort Incorrectly as Date Type =

Article ID: 140181

Article Last Modified on 8/17/2005

-

APPLIES TO


 * Microsoft Word 6.0 Standard Edition
 * Microsoft Word 6.0a
 * Microsoft Word 6.0c
 * Microsoft Word 6.0 for Macintosh
 * Microsoft Word 6.01 for Macintosh
 * Microsoft Word 6.01 for Macintosh
 * Microsoft Word 6.0 Standard Edition
 * Microsoft Word 95 Standard Edition
 * Microsoft Word 95a
 * Microsoft Word 98 for Macintosh

-



This article was previously published under Q140181





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.

Keywords: kbualink97 kbtable kbprb KB140181

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.