Date range filtering not working

[vedran_nincevic]

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)

In “Izvjestaji” table, in “New Column A” (If -Then -Else column), I see only rows from “Izvjestaji” table.

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

[Darren_Murphy]

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.

[vedran_nincevic]

It works thank you very much