Crystal Reports for Eclipse Designer Guide

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).



SAP BusinessObjects
http://www.sap.com/sapbusinessobjects/
Support services
http://service.sap.com/bosap-support/
Product Documentation on the Web
http://help.sap.com/