Row filter for today's month

[Yehuda_Bruck]

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.

[Steve]

Try:

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

See also:

help.appsheet.com

EOMONTH()

Date of last day of a month from Date or DateTime

[LeventK · Accepted solution]

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

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

[Steve]

&& is not a thing in AppSheet. Instead:

help.appsheet.com

AND()

Are all true?