# Date Filtering

**URL:** <https://community.glideapps.com/t/date-filtering/87012>\
**Category:** Ask for Help\
**Created:** [May 5, 2026, 11:36am UTC](https://community.glideapps.com/t/date-filtering/87012 "2026-05-05T11:36:12Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![LaurenWepener](https://avatars.discourse-cdn.com/v4/letter/l/90db22/32.png) [@LaurenWepener](https://community.glideapps.com/u/LaurenWepener)\
**Post date:** [May 5, 2026, 11:36am UTC](https://community.glideapps.com/t/date-filtering/87012/1 "2026-05-05T11:36:12Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [May 5, 2026, 11:45am UTC](https://community.glideapps.com/t/date-filtering/87012/2 "2026-05-05T11:45:01Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![LaurenWepener](https://avatars.discourse-cdn.com/v4/letter/l/90db22/32.png) [@LaurenWepener](https://community.glideapps.com/u/LaurenWepener)\
**Post date:** [May 5, 2026, 11:53am UTC](https://community.glideapps.com/t/date-filtering/87012/3 "2026-05-05T11:53:52Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [May 12, 2026, 11:54am UTC](https://community.glideapps.com/t/date-filtering/87012/4 "2026-05-12T11:54:24Z")

</div>

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.