Current Month Number

[Dave_Willett]

Hi.

This expression returns rows for the current month:

AND
(YEAR([InvoicedDate]) = YEAR(TODAY()),
MONTH([InvoicedDate]) = MONTH(TODAY())
)

But I need a variation. I have a table which will contain data the current Qtr and for the month I only have the month number.
I’e
4 (April)
5 (May)

So I need an expression which will return rows with the current months data where the month number ( 5 in this case ) equa;s the current month.

Can this be done as I have no actual dates in the table.

Thank You