# Filtering list by within today not working (900pm EST)
**URL:** https://community.glideapps.com/t/filtering-list-by-within-today-not-working-900pm-est/73085
**Category:** Ask for Help
**Created:** [May 5, 2024, 2:28am UTC](https://community.glideapps.com/t/filtering-list-by-within-today-not-working-900pm-est/73085 "2024-05-05T02:28:43Z")
**Posts on this page:** 16
**Page:** 1
### Author:  [@JWazar](https://community.glideapps.com/u/JWazar)
#### Post date: [May 5, 2024, 2:28am UTC](https://community.glideapps.com/t/filtering-list-by-within-today-not-working-900pm-est/73085/1 "2024-05-05T02:28:43Z")
([Glide](https://go.glideapps.com/o/LPtnyneZqAKgtQcW75KQ/f/e3376755-347f-4e58-9370-9ebd9e96ff4a))
([Glide](https://go.glideapps.com/app/bYWEipinuFdc1IfUx2cs/layout))
**Description**
- Trying to filter a list for records created WITHIN TODAY. No records return. However this was working as expected prior to 900pm EST. In serching for similiar reported bugs a found a few that seemed similiar but were resolved after some time passed. Not sure if I am doing something wrong here or if this is a known issue.
**How to replicate**
- Place filter for within today on any date field and list does not return any result.
---
### Author:  [@JWazar](https://community.glideapps.com/u/JWazar)
#### Post date: [May 5, 2024, 2:57am UTC](https://community.glideapps.com/t/filtering-list-by-within-today-not-working-900pm-est/73085/2 "2024-05-05T02:57:48Z")
I also tested with a querry column, it would seem that there is for sure something wrong with how glide is handling the within today date/time calculation in filter type processes.
Has anyone else encounterd this situation or can someone try it out and let me know if im missing something. Being able to filter list by “within today” is actually an important part of the app I am designing.
\*if it makes a diffrence, I am using SQL tables
Thanks
---
### Author:  [@JWazar](https://community.glideapps.com/u/JWazar)
#### Post date: [May 5, 2024, 4:17am UTC](https://community.glideapps.com/t/filtering-list-by-within-today-not-working-900pm-est/73085/3 "2024-05-05T04:17:37Z")
It is now 1210am EST (5/5/2024) and the filters are working as expected. All records created starting at 1200am are correctly filterd for “within today”.
The issue seems to impact only the hours between 900pm and 1200am.
Am i missing something or is this a legit issue related to using SQL tables? I ask becuase all other tables not SQL type did not have this issue.
---
### Author:  [@Sekayi\_Liburd](https://community.glideapps.com/u/Sekayi_Liburd)
#### Post date: [May 5, 2024, 5:20am UTC](https://community.glideapps.com/t/filtering-list-by-within-today-not-working-900pm-est/73085/4 "2024-05-05T05:20:27Z")
I’m not sure of your problem with SQL tables since I don’t use these but I would say that the last time I had a similar problem, it was because I added a new column for tags and neglected to switch my filter to pull from the new column - so newest row entries weren’t appearing in the filter.
All this to say, double-check all your connecting data in your SQL tables in case there’s something that needs updating.
---
### Author:  [@JWazar](https://community.glideapps.com/u/JWazar)
#### Post date: [May 5, 2024, 11:46pm UTC](https://community.glideapps.com/t/filtering-list-by-within-today-not-working-900pm-est/73085/5 "2024-05-05T23:46:52Z")
Thanks.
Not sure really. I checked for filters and the like. Crazy thing is how it stopped working at 900pm and came back at 1200am. Im going to see what happens tonight.
Appreciate your reply!
---
### Author:  [@JWazar](https://community.glideapps.com/u/JWazar)
#### Post date: [May 6, 2024, 3:31pm UTC](https://community.glideapps.com/t/filtering-list-by-within-today-not-working-900pm-est/73085/6 "2024-05-06T15:31:16Z")
Yes, every day from 900pm EST to 1200AM EST this occures. IT only impacts the tables I have with SQL as source.
Will be reaching out to support on this later today.
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [May 6, 2024, 3:42pm UTC](https://community.glideapps.com/t/filtering-list-by-within-today-not-working-900pm-est/73085/7 "2024-05-06T15:42:06Z")
My guess would be that it has something to do with your timezone.
Are you by chance 3 hours behind UTC?
It could be that Glide is reading your dates/times as UTC instead of local time.
---
### Author:  [@JWazar](https://community.glideapps.com/u/JWazar)
#### Post date: [May 6, 2024, 5:19pm UTC](https://community.glideapps.com/t/filtering-list-by-within-today-not-working-900pm-est/73085/8 "2024-05-06T17:19:10Z")
Good observation Darren. Im on Eastern Standard Time. If this is the case, what should I do or what would be the best way to account for this?
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [May 6, 2024, 5:49pm UTC](https://community.glideapps.com/t/filtering-list-by-within-today-not-working-900pm-est/73085/9 "2024-05-06T17:49:36Z")
How do you populate the date column? Do you use ‘Respect Time Zone’ in that column?
---
### Author:  [@JWazar](https://community.glideapps.com/u/JWazar)
#### Post date: [May 6, 2024, 7:23pm UTC](https://community.glideapps.com/t/filtering-list-by-within-today-not-working-900pm-est/73085/10 "2024-05-06T19:23:22Z")
Thats the thing, Its a SQL Table so I dont actually have the ability to set that toggle. My understanding is that new fields have to be created in SQL DB, only row ID type and computed/integration fields can be added in builder with table of this source:
… My question is, How do make it so the “within today” feature works as expected? Is there something I would need to do on the SQL side to align the times? Some kind of seeting?
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [May 6, 2024, 8:53pm UTC](https://community.glideapps.com/t/filtering-list-by-within-today-not-working-900pm-est/73085/11 "2024-05-06T20:53:54Z")
> [@JWazar](#):
>
> My question is, How do make it so the “within today” feature works as expected?
That’s what I’m trying to determine. Like Darren mentioned, it’s probably treating the time like utc time, so for a few hours of the day utc time is a different day. I think the difference can be how the date time is formatted. Not sure if this issue is specific to SQL sources or not, but these kinds of things seem to be more common with external data sources. Dates can be tricky sometimes.
I guess the easy way out is to create a couple of math columns. One that converts your date column into a numeric YYYYMMDD and the same for the current date (Now). Set up two math columns like this:
```auto
Year(date)*10^4 +
Month(date)*10^2 +
Day(date)
```
In one, replace date with your date column and in the other replace date with ‘Now’. Then set your filter to compare the two numbers.
---
### Author:  [@JWazar](https://community.glideapps.com/u/JWazar)
#### Post date: [May 6, 2024, 9:30pm UTC](https://community.glideapps.com/t/filtering-list-by-within-today-not-working-900pm-est/73085/12 "2024-05-06T21:30:08Z")
it curious actually Jeff, I saw you provide a similiar recomendation to an other user. I created the fields and they returned exactly the expected value, THEN I realized that for SQL tables you can not set FILTER or SORT conditions based on columns NOT in the SQL table, meaning - cant use computed columns as filter.
Yeah, Starting to get concerned about this issue. We dont deploy for anther 2-3 weeks, but I really need to find a solutiuon for this.
Thanks for you advice and help, much appreciated!
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [May 6, 2024, 10:16pm UTC](https://community.glideapps.com/t/filtering-list-by-within-today-not-working-900pm-est/73085/13 "2024-05-06T22:16:16Z")
Can you do something similar in the SQL statement? What does your SQL look like?
---
### Author:  [@JWazar](https://community.glideapps.com/u/JWazar)
#### Post date: [May 7, 2024, 6:53pm UTC](https://community.glideapps.com/t/filtering-list-by-within-today-not-working-900pm-est/73085/14 "2024-05-07T18:53:52Z")
Im actually just using the SQL Table as a table in Glide, not a querry.
I am thinking of testing to see if editing the system on the SQL side solves this issue…
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [May 7, 2024, 7:46pm UTC](https://community.glideapps.com/t/filtering-list-by-within-today-not-working-900pm-est/73085/15 "2024-05-07T19:46:54Z")
Got it. Yeah, I’m just throwing out random ideas at this point Since I haven’t used an SQL data source in any of my apps, I’m not sure of all the limitations. Hopefully someone else who has used it has some thoughts.
---
### Author:  [@system](https://community.glideapps.com/u/system)
#### Post date: [November 3, 2024, 7:47pm UTC](https://community.glideapps.com/t/filtering-list-by-within-today-not-working-900pm-est/73085/16 "2024-11-03T19:47:26Z")
This topic was automatically closed 180 days after the last reply. New replies are no longer allowed.