Works: Trouble Querying for Dates Beyond 1999 (132471)


The information in this article applies to:

  • Microsoft Works 2.0
  • Microsoft Works 2.0a
  • Microsoft Works 3.0
  • Microsoft Works 3.0a
  • Microsoft Works 3.0b
  • Microsoft Works for the Macintosh 2.0a
  • Microsoft Works for the Macintosh 2.0b
  • Microsoft Works for the Macintosh 2.0c
  • Microsoft Works for the Macintosh 2.0d
  • Microsoft Works for the Macintosh 2.0e
  • Microsoft Works for the Macintosh 3.0
  • Microsoft Works for the Macintosh 3.0a
  • Microsoft Works for the Macintosh 4.0
  • Microsoft Works for the Macintosh 4.0a
  • Microsoft Works for the Macintosh 4.0b
  • Microsoft Works for the Macintosh 4.0c
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.

REFERENCES

Microsoft Works 3.x: "Microsoft Works User's Guide" page 207

Microsoft Works 2.x: "Microsoft Works User's Guide" page 268
Modification Type:MajorLast Reviewed:7/17/2006
Keywords:kbprb KB132471
©2004 Microsoft Corporation. All rights reserved.