Works: Trouble Querying for Dates Beyond 1999 |
The information in this article applies to:
-
Microsoft Works for Windows, versions 2.0, 2.0a, 3.0, 3.0a, 3.0b
-
Microsoft Works for the Macintosh, versions 2.0a, 2.0b, 2.0c, 2.0d, 2.0e, 3.0, 3.0a, 4.0, 4.0a, 4.0b, 4.0c
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:
- Double-click Control Panel, usually located in the Main program group.
- Double-click the International icon.
- In the Date Format section, click Change.
- In the Short Date Format section of the dialog box, make sure the
Century box is checked. Click OK.
- Click OK in the International settings dialog box. Close the Control
Panel. Your short dates now include the century.
Windows 95/98
- Click Start, point to Settings, and then click Control Panel.
- Double-click Regional Settings. Click the Date tab.
- In the Short Date Style section, click MM/dd/yyyy. Click OK.
- 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. ALL SUCH INFORMATION IS PROVIDED TO YOU PURSUANT TO THE TERMS AND CONDITIONS SET FORTH AT MICROSOFT'S YEAR 2000 WEBSITE LOCATED AT http://microsoft.com/year2000. MICROSOFT THEREFORE RECOMMENDS THAT YOU CHECK THE YEAR 2000 WEBSITE REGULARLY FOR ANY CHANGES TO ANY MICROSOFT YEAR 2000 STATEMENT. ALL SUCH INFORMATION IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND AND PROVIDED AS A YEAR 2000 READINESS DISCLOSURE.
REFERENCES
Microsoft Works 3.x: "Microsoft Works User's Guide" page 207
Microsoft Works 2.x: "Microsoft Works User's Guide" page 268
Additional query words:
w_works match matched find found didn't future failed unable filter Y2K Year 2000 millennium two-thousand two thousand kbimu
Keywords : kb2000
Version : MACINTOSH:2.0a,2.0b,2.0c,2.0d,2.0e,3.0,3.0a,4.0,4.0a,4.0b,4.0c; WINDOWS:2.0,2.0a,3.0,3.0a,3.0b
Platform : MACINTOSH WINDOWS
Issue type : kbprb
