>I tried to create a report that would extact all the MONTH(DATE()) from a 'date field'(filter)but it gives me an error "operator/operant type mistmach" . Can anybody tell me what I'm doing wrong? if this is incorrect way to extract all the records from the current month, then what is the right way?
>thanks.
Edgar,
The expression that will get all records for the current month would be;
MONTH(Date_field) = MONTH(DATE())