About the Dates and timezones category

Topic Labels: Dates & Timezones
1235 2
Showing results for 
Search instead for 
Did you mean: 
2 Replies 2
5 - Automation Enthusiast
5 - Automation Enthusiast

I am using the Airtable’s Supported timezones for SET_TIMEZONE and I am getting an incorrect calculation.
I have sessions scheduled in my table for Adelaide, Australia ACST time and have added in the a calculation (ScottWorld’s formula) so it shows my local time of Sydney, Australia, which is 30 minutes difference. However my table is showing a 1 hour difference instead of the correct 30 minutes difference.
How do I fix this so it is showing the correct time difference?

Screen Shot 2021-05-11 at 4.12.34 pm
Screen Shot 2021-05-11 at 4.09.16 pm

Thanks :slightly_smiling_face:

5 - Automation Enthusiast
5 - Automation Enthusiast

Thanks Jason, I have looked at all of those articles and unfortunately they don’t answer my question.

I am using Airtables supported timezones which seem to be calculating correctly for all time zones but Australia/Adelaide. It is showing as 9 hour off set from GMT time in Airtable but should be 9.30 hours off set from GMT time.

How do I fix this?

Screen Shot 2021-05-13 at 12.39.46 pm

Screen Shot 2021-05-13 at 12.41.17 pm