As far as I know, there isn’t anywhere in the app where you can define the timezone of the app, and I think this makes sense, as timezone really depends on the user, not the app.
When you create a Date column, there is a checkbox indicating to take into account user timezone.
If all of your users are in the same timezone (Michigan) and your app seems to be off by 8 hours, maybe you could create a new time column and create an 8-hour offset?
I have the same situation. Can you explain the set up for this 8 hour offset?
I’ve spent an hour trying to puzzle through. Every idea still compares to 12am UTC, which will result in wrong displays. As far as I can tell, the offset needs to be applied to TODAY, not the date in the data. What am I missing?