HP Intelligent Management Center Standard Software Platform - Manual (Page 201)

Selects those records in which the value in the {file.FIELD} field is greater
than 11111 but less than 99999 (both 11111 and 99999 are included in the
range of values).
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).
Selecting records using preset date ranges
The preset date ranges can be used to create selection formulas similar to
these:
{file.DATE} in LastFullMonth
Crystal Reports 2008 SP3 User's Guide 201
9 Record Selection
Using formula templates