Current Month Number

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

I believe the filter expression for the current month’s rows will will be

MONTH(TODAY())=[Month Number]

Where [Month Number] is the column that has month numbers in the format 4, 5, 6 . Assumed to be number type column

2 Likes

Spot on, Thank You Suvrutt.

2 Likes