# Date range filtering not working

**URL:** <https://community.glideapps.com/t/date-range-filtering-not-working/69842>\
**Category:** Ask for Help\
**Created:** [January 22, 2024, 5:42am UTC](https://community.glideapps.com/t/date-range-filtering-not-working/69842 "2024-01-22T05:42:28Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![vedran\_nincevic](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/vedran_nincevic/32/69441_2.png) [@vedran\_nincevic](https://community.glideapps.com/u/vedran_nincevic)\
**Post date:** [January 22, 2024, 5:42am UTC](https://community.glideapps.com/t/date-range-filtering-not-working/69842/1 "2024-01-22T05:42:28Z")

</div>

Hi,  
I am trying to make date range filtering of “Nalozi” table.  
I would like to make reports of this “Nalozi” table in new screen called “Izvjestaji”.  
Reports will be based on data in “Naloziarray” column (Raspon is croatian for Range)

 ![Screenshot220124_1](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/b/5b1b20c25ccd3d1d631cab6323cd101b032444ae.png)  
 ![Screenshot220124_2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/b/ab2075a88476f5993b0c56c5e7d9eceece88e822.png)  
 ![Screenshot220124_3](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/0/a0fdb983598387c90edc64d523a076bc11147ddc.png)  
In “Izvjestaji” table, in “New Column A” (If -Then -Else column), I see only rows from “Izvjestaji” table.  
 ![Screenshot220124_4](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/8/38f5a2ce0ce4545fafdd4faffd88a8100bffb2cd.png)  
Am I seeing only rows in “Izvjestaji” table, because “Izvjestaji” table is Glide table, and other tables are Airtable tables?

How do I connect “Izvjestaji” table to “Nalozi” table to make this filtering work?  
Thank you very much

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [January 22, 2024, 5:59am UTC](https://community.glideapps.com/t/date-range-filtering-not-working/69842/2 "2024-01-22T05:59:06Z")

</div>

I see two Single Value columns in your Nalozi table - are they taken from the Izvjestaji table?

If yes, then you should add an if-then-else column in the Nalozi table, and refer to those Single Value columns. The if-then-else will be something like:

- If Start is less than Single Value Start, then null
- If End is greater than Single Value End, then null
- Else true

And you can use that if-then-else column as a filter on your Nalozi table, only showing rows where it is checked.

---

<div class="post-metadata">

**Author:** ![vedran\_nincevic](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/vedran_nincevic/32/69441_2.png) [@vedran\_nincevic](https://community.glideapps.com/u/vedran_nincevic)\
**Post date:** [January 23, 2024, 4:45am UTC](https://community.glideapps.com/t/date-range-filtering-not-working/69842/3 "2024-01-23T04:45:33Z")

</div>

It works 🙂 thank you very much

---

<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:** [January 30, 2024, 4:46am UTC](https://community.glideapps.com/t/date-range-filtering-not-working/69842/4 "2024-01-30T04:46:28Z")

</div>

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