#### Selecting records using preset data ranges

The preset date ranges can be used to create selection formulas similar to these:

`{file.DATE} in LastFullMonth`

Selects those records in which the date found in the {file.DATE} field falls within the last full month. (If the month is May, this selects all records with an April date.)

`not({file.DATE} in LastFullMonth)`

Selects all records except those in which the date found in the {file.DATE} field falls within the last full month (if the month is May, this selects all records except those with an April date).

`{file.DATE} < CurrentDate`

Selects all records in which the date found in the {file.DATE} field falls before today's date.

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