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



Thanks Jim, I'll try this right now.