Timezone for Time Column in "Balance History"

Hey!

So there are a couple different answers to this question. I’ll hopefully answer your specific question as much as possible but provide some caveats.

The specific balance histories you have circled there are showing the UTC values. Meaning the balance was recorded on 12/02/2021 at 3:53AM UTC. I looked that balance entry up on our backend and confirmed that.

Now the caveats: unfortunately the client-side code handles date/time fields inconsistently, so it’s really difficult to say with certainty that any specific column is displayed in a specific timezone. In some cases (mostly older sheets on a legacy system) the dates are PST. Unfortunately there’s no sure way to know for sure based solely on the sheet’s data. This is something we want to fix but haven’t been able to.

-Brasten

2 Likes