Row filter for today's month

AppSheet AppSheet Q&A
1

Hi, I’m new to AppSheet and I need help with Expressions:

I’m trying to create a Slice that will only filter data from the current month.
In the data table I also have data from 2019 so I used this Expression:

YEAR([Date]) = YEAR(TODAY()) && MONTH([Date]) = MONTH(TODAY())

For some reason it does not work…

I would appreciate your help,
Yehuda.

2

Try:

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

See also:

2 Likes
3

@Yehuda_Bruck
Your expression’s syntax is not correct. It shall be:

AND(
    YEAR([Date]) = YEAR(TODAY()),
    MONTH([Date]) = MONTH(TODAY())
)
4 Likes
4

&& is not a thing in AppSheet. Instead:

5 Likes