Microsoft KB Archive/50717

From BetaArchive Wiki

Works: Querying for Records Between Two Dates

PSS ID Number: Q50717 Article last modified on 10-16-1998

1.00 1.05 2.00 3.00


====================================================================== 1.00 1.05 2.00 3.00 MS-DOS kbother

The information in this article applies to:
- Microsoft Works for MS-DOS, versions 1.x, 2.0 and 3.0

To query for database records that lie on or between two dates, use a formula in the form of the following example:

For records with dates between 1/1/89 and 2/15/89, enter the following formula in the “Date:” field of the Query screen:

Works 3.0:


Works 1.x and 2.0:


To enter a query, choose Query from the View menu in Works version 2.0 and 3.0 (choose Query Define in Works versions 1.x) and type the formula in the “Date:” field. To see the results of the query, press F10 to return to List view.

KBCategory: kbother KBSubcategory: dworkskb Additional reference words: ====================================================================== Version : 1.00 1.05 2.00 3.00 Platform : MS-DOS ============================================================================= Copyright Microsoft Corporation 1998.