User`s guide

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).
7.2.1.4 Selecting records using preset date 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).
7.2.1.5 Selecting records using date/number/character combinations
These formulas simply "mix and match" formulas from the categories above.
"C" in {file.FIELD}[1] and Month({file.DATE}) in [1,4]
Selects those records in which the value in the {file.FIELD} field begins with "C" and the month is either
January or April. For example, if this kind of formula was used with an order database, you could be
asking for a report showing all customers whose names begin with "C" and who placed orders in January
or in April.
"AOK" in {file.HISTORY}[3 to 5] and {file.OPENCRED} >= 5000
Selects those records in which the {file.HISTORY} field shows the characters "AOK" as the 3, 4, and 5
characters and the {file.OPENCRED} field (the amount of available credit) is at least 5000.
2012-03-14136
Record Selection