Date Filtering

Ask for Help
1

I have set up my data table by extracting the month and year using computed math columns.
I then used If month = x then true and If year = y then true ELSE false.
The screen filter is set up to if Month = x AND if Year = Y.
All the computations are working in the table.
Yet, when my date picker picks an entry for May when everything is set up for month 5 and year 2026 the entry does not display. If I enter an entry for April. It does show.

What is up with this?

2

IF columns didn’t have And/Or logic. It’s ElseIf logic, so technically it’s Month OR Year..whichever is true first. But it sounds like you are not using the IF column anyway.

Share screenshots of your setup for the math columns, If column, and filter so we can see what it’s doing.

3

Hey Jeff, I removed the year and that seems to have cured the problem.
Love the explanation!