This expression returns rows for the current month:
(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.
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.