I built a DB table that tracks details about every snippet every time any of my users uses any snippet. One of my table views is "Todays Usage". The problem I am having is that while the first column called 'when' is populating the time accurately to EST, the table filters time in UTC. This means that at any snippet run after 7pm EST every day is not showing up in the "Todays Usage" view. Any ideas?
Here is a screenshot of part of the table (pii greyed out )
The problem here seems to be related to passing the date through dbinsert. It is missing timezone and therefore DB accepts it as if it was in UTC. To fix that you can use ZZ token which will add timezone information - {when={time: LLL ZZ}}. This should make both date and filter match properly in UTC.