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.