My Deadline column is in a Glide Big Table, and the Query column is in a regular Glide Table.
I’m trying to query rows where the deadline is today. My timezone is KST (UTC+9).
Today is June 2, 2026.
[Screenshot 1 - Tasks table]
The Tasks table has 5 rows.
June 2 rows are #4 and #5, June 3 is #3.
[Screenshot 2 - Attempt 1]
I created a Query column with filter
Deadline > is within > today.Expected: June 2 rows.
[Screenshot 3 - Attempt 1 result]
The result returns June 3 (06-03) instead of June 2. Wrong result.
[Screenshot 4 - Attempt 2]
To work around this, I created an ITE column: IF Deadline is within today → TRUE, ELSE → FALSE.
June 2 rows (#4, #5) correctly show TRUE, June 3 row (#3) shows FALSE.
[Screenshot 5 - Attempt 3]
I then used this ITE result in a Query filter (Deadline ITE > is checked).
But it still returns June 3 — same wrong result.
It seems like is within today is calculated based on UTC, not the user’s local timezone.
For KST users (UTC+9), this causes tomorrow’s date to match instead of today’s.
Tested at: June 2, 2026, 4:56 PM KST (UTC: June 2, 07:56 AM)
I believe this might be a new bug. If I recall correctly, this was working fine a few days ago and I don’t remember having this issue before.
[Additional Issue]
I have the same issue in a different context. I have a table with Start and End date columns, and I’m trying to query rows where today falls within the date range.
I built a chain of ITE columns:
- ITE 1: IF Start is on or before today → return Start (confirms the row has already started)
[Screenshot A - ITE 1 configuration]
- ITE 2: IF ITE 1 is not empty → return End (gets the end date)
[Screenshot B - ITE 2 configuration]
- ITE 3: IF ITE 2 is on or after today → true (confirms it hasn’t ended yet)
[Screenshot C - ITE 3 configuration]
In the table view, ITE 3 correctly shows TRUE for rows where today falls within the range (e.g. May 29 ~ June 5).
[Screenshot D - Table view showing ITE 1, 2, 3 results]
However, when I use ITE 3 is checked as a Query filter, it returns no results — completely ignoring the TRUE values.
[Screenshot E - Query filter configuration, Empty query result]
Same underlying issue: The root cause appears to be that date comparisons involving today do not work correctly in Glide.