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
Spot on, Thank You Suvrutt.
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |