>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.
I'm betting that your date is a character field, not a date. Try MONTH(CTOD(date field))
"You don't manage people. You manage things - people you lead" Adm. Grace Hopper
Pflugerville, between a Rock and a Weird Place