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,109
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