# “Today” Date Filter Rolls Over at 8:00 PM Eastern Instead of Midnight **URL:** \ **Category:** Ask for Help\ **Created:** [September 14, 2026, 11:44am UTC](https://community.glideapps.com/t/today-date-filter-rolls-over-at-8-00-pm-eastern-instead-of-midnight/87691 "2026-09-14T11:44:45Z")\ **Posts on this page:** 1\ **Page:** 1
**Author:** ![RayG](https://avatars.discourse-cdn.com/v4/letter/r/977dab/32.png) [@RayG](https://community.glideapps.com/u/RayG)\ **Post date:** [September 14, 2026, 11:44am UTC](https://community.glideapps.com/t/today-date-filter-rolls-over-at-8-00-pm-eastern-instead-of-midnight/87691/1 "2026-09-14T11:44:46Z")
Hi everyone, I’m trying to solve a date/time issue in a Glide app we use for daily delivery routes. We have a **Route Date** column and a “Today” view that should display only routes scheduled for the current day. Our users are in Michigan (Eastern Time), and we need the operational day to change at **midnight Eastern**. Instead, the app appears to roll over at approximately **8:00 PM Eastern**. I ran a controlled test Sunday 9/13: - At **7:45 PM Eastern** , the app was blank because there were no Sunday routes. - Monday 9/14 routes were already loaded in the data. - At approximately **8:00 PM Eastern Sunday** , the app began rolling over to Monday. - By **8:09 PM Eastern** , the Monday 9/14 routes were visible. Because 8:00 PM Eastern currently corresponds to **midnight UTC** , it appears that the “Today” calculation/filter may be changing dates based on UTC rather than Eastern Time. We have experimented with the **Respect time zones** setting on the Route Date column, but the 8:00 PM rollover still occurs. **What is the correct way in Glide to create a “Today” filter that changes at midnight in the user’s/app’s Eastern Time zone rather than midnight UTC?** Our desired behavior is simple: Sunday routes should remain the current routes through **11:59 PM Eastern** , and Monday routes should not become “Today” until **12:00 AM Eastern**. Is there a recommended way to accomplish this using **Route Date, Respect time zones, Current Date/Time, or an If-Then-Else computed column?** Thanks for any help.