#### Selecting records using dates

The Month, Day, and Year functions can all be used in examples like the following:

`Year ({file.DATE}) < 1999`

Selects those records in which the year found in the {file.DATE} field is earlier than 1999.

    Year ({file.DATE}) > 1992 and
    Year ({file.DATE}) < 1996
    Selects those records in which the year found in the {file.DATE} field falls between 1992 and 1996 (1992 and 1996 not included).Year({file.DATE}) >= 1992 and
    Year({file.DATE}) <= 1996
    Selects those records in which the year found in the {file.DATE} field falls between 1992 and 1996 (1992 and 1996 are included).

`Month({file.DATE}) in 1 to 4`

Selects those records in which the month found in the {file.DATE} field is one of the first four months of the year (includes January, February, March, and April).

`Month({file.DATE}) in [1,4]`

Selects those records in which the month found in the {file.DATE} field is the first or fourth month of the year (includes January and April, excludes February and March).

Seagate Software, Inc. http://www.seagatesoftware.com Please send comments to: techpubs@seagatesoftware.com