I’d like to have a “Date” fields in my table, where the user selects a date with the date picker, and then have the calendar show that exact date. This obviously works when browser timezone is PST, but if it is anything else, the calendar will show times such as “10:00 AM” with the dates - and obviously sometimes will show the event on the wrong day, if the browser timezone moves it to the previous day.
Now, my users are all in the same timezone, and I actually mean that my dates are in a specific timezone. I can create a new field with a formula that allows me to do something like
Concatenate(Date, " 00:00 EST") which gives me correct dates in a different timezone. However, I am not in “EST”, but in “EET” (Finland) - and Coda does not understand the “EET” timezone. I can put in “+02:00” instead of the timezone, but that unfortunately does not take daylight savings in to account when we use “+03:00”, so the dates are mostly off.
The best I have come up with is simply saying
Date-Hours(10), which correctly offset the time for my timezone, both winter time and summer time - but unfortunately EU transfers to summer time at a different time than PST, so there are a few dates in the middle where the shift is wrong.
So I have no idea how to create a formula that would shift the dates properly, or anything that would solve my issue.
Honestly, I want timezone agnostic dates. The event happens on a certain date, at a local location, and it will just be terribly confusing if it shows on a different day for a foreign visitor. If they would arrive for the event, they obviously will use local dates here to plan.
So, the one fix that would solve everything for me - make Calendar view always show everything in PST, regardless of browser time zone - if support for timezone agnostic dates are not to be added.