Slice that only shows rows with the current month

Hello!
I was trying to create a slice to only show me rows from the current month.
for the row filter condition i put:
AND( MONTH([Date]) = MONTH(TODAY()), YEAR([Date]) = YEAR(TODAY()))

when i save the expression assistant it shows me the right results in the app preview but when i save and reload the app it doesnt work anymore.

is the formula correct? Thank you for the help!

Emilio

Solved Solved
0 3 1,100
1 ACCEPTED SOLUTION

Hi

Try this please

TEXT([Date],โ€œMMYYYYโ€)=TEXT(TODAY(),โ€œMMYYYYโ€)

View solution in original post

3 REPLIES 3

Hi

Try this please

TEXT([Date],โ€œMMYYYYโ€)=TEXT(TODAY(),โ€œMMYYYYโ€)

Steve
Platinum 4
Platinum 4

Try:

 (EOMONTH(TODAY(), 0) = EOMONTH([Date], 0))

Hi all.
Iโ€™m struggling with the same issue?
Tried both expressions below in a slice but still not working for me.
The expression works when I run a test but does not feedback to app?

Iโ€™ve added one screenshot, newbie limit, showing both test and slice with app.

Any help will be appreciated!

Top Labels in this Space