(Glide)
(Glide)
Description
How to replicate
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
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.
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.
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!
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.
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.
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?
How do you populate the date column? Do you use ‘Respect Time Zone’ in that column?
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?
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:
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.
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!
Can you do something similar in the SQL statement? What does your SQL look like?
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…
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.
This topic was automatically closed 180 days after the last reply. New replies are no longer allowed.