Microsoft KB Archive/132471

= Works: Trouble Querying for Dates Beyond 1999 =

Article ID: 132471

Article Last Modified on 7/17/2006

-

APPLIES TO


 * Microsoft Works 2.0 Standard Edition
 * Microsoft Works 2.0a
 * Microsoft Works 3.0 Standard Edition
 * Microsoft Works 3.0a
 * Microsoft Works 3.0b
 * Microsoft Works 2.0a for Macintosh
 * Microsoft Works 2.0b for Macintosh
 * Microsoft Works 2.0d for Macintosh
 * Microsoft Works 2.0d for Macintosh
 * Microsoft Works 2.0e for Macintosh
 * Microsoft Works 3.0 for Macintosh
 * Microsoft Works 3.0a for Macintosh
 * Microsoft Works 4.0 for Macintosh
 * Microsoft Works 4.0a for Macintosh
 * Microsoft Works 2.0e for Macintosh
 * Microsoft Works 4.0c for Macintosh

-



This article was previously published under Q132471



SYMPTOMS
When you try to query on dates in the 21st century, your Works Database search fails and you may receive an error message similar to the following:

  No records matched the criteria



CAUSE
Works assumes dates typed in the MM/DD/YY format refer to the 20th century. For example, if you type 1/1/95, Works assumes you mean January 1, 1995. However, if you type 1/1/01, Works assumes you mean January 1, 1901, even though the 2001 is closer to the current date.



RESOLUTION
When you initially type dates and querying on dates, type the full year. For example, query on "1/1/2001" (without the quotation marks). This correctly matches records that display as "1/1/01", as long as the records were initially typed as "1/1/2001".



MORE INFORMATION
It is also possible to change the default short date format to show the century. Use the steps appropriate for your version of Windows.

Windows 3.x
To show the century in dates, do the following:


 * 1) Double-click Control Panel, usually located in the Main program group.
 * 2) Double-click the International icon.
 * 3) In the Date Format section, click Change.
 * 4) In the Short Date Format section of the dialog box, make sure the Century box is checked. Click OK.
 * 5) Click OK in the International settings dialog box. Close the Control Panel. Your short dates now include the century.

Windows 95/98

 * 1) Click Start, point to Settings, and then click Control Panel.
 * 2) Double-click Regional Settings. Click the Date tab.
 * 3) In the Short Date Style section, click MM/dd/yyyy. Click OK.
 * 4) Close the Control Panel. Your short dates now include the century.

ALL COMMUNICATIONS OR CONVEYANCES OF INFORMATION TO YOU CONCERNING MICROSOFT AND THE YEAR 2000 REFLECTS INFORMATION THAT IS CURRENTLY AVAILABLE AND SUBJECT TO CHANGE AT ANY TIME WITHOUT NOTICE.

