Microsoft KB Archive/50717

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

MS-DOS

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

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:
=‘1/1/89’#AND#<=‘2/15/89’

Works 1.x and 2.0:
=‘1/1/89’&<=‘2/15/89’ 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.