CURRENT_MONTH - Find Invoices in current month -syntax ?

ACDC

I have a mental block here, I am trying structure a query to FIND all Invoices in the current month, I thought this would be simple enough using CURRENT_MONTH, but this only returns an integer of 1-12 and the year is absent

Something like:
FIND Invoice WHERE Invoice.Date=CURRENT_MONTH

or
FIND Invoice WHERE CURRENT_MONTH(Invoice.date)=CURRENT_MONTH

None of these work, does anybody have a suggestion as to the most efficient way of doing this

rocketman

FIND Invoice WHERE MONTH(Invoice.date)=CURRENT_MONTH

You was close

ACDC

Yep, staring at me right in the face - only thing though it needs the CURRENT_YEAR part as well, otherwise all the previous years for that month are returned'

FIND Invoice WHERE MONTH(Invoice.date)=CURRENT_MONTH AND YEAR(Invoice.date)=CURRENT_YEAR