Microsoft KB Archive/50717

From BetaArchive Wiki
< Microsoft KB Archive
Revision as of 18:25, 12 August 2020 by X010 (talk | contribs) (X010 moved page Microsoft KB Archive/Q50717 to Microsoft KB Archive/50717 without leaving a redirect: Text replacement - "Microsoft KB Archive/Q" to "Microsoft KB Archive/")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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

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:

=‘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.