Skip to main content
Question

Getting dates right with DST, time zones and scripting blocks

  • March 19, 2025
  • 1 reply
  • 65 views

Forum|alt.badge.img+4

Hello

Apologies if this has been asked before but I can’t find a solution that works. I have a base where all times should be for UK/London (it is scheduling of spaces in a building), wherever in the world I am I want any date or time entered to be UK time. Thankfully Airtable have now fixed this in the normal UI, but I am struggling to find a way of achieving this for dates entered via a script in a script block (not an automation) - I have an input.text field and can parse the date and time, but currently that time will always be based on the time zone of my browser, not the base.

 

Does anyone know of a good bit of code to sort this out - I wonder if I should use offset. but I worry this would not work for DST?

1 reply

hwmedhin
Forum|alt.badge.img
  • Community Manager
  • 8 replies
  • April 24, 2025

Hey there ​@Richard_Willia1, thanks for submitting such a great question! Because your question hasn't yet received an answer/solution from the Community, we've created s support case on your behalf with our Airtable Expert Team to get you the quickest, best response possible. Please check your email for follow-up and your case reference number—and continue to follow this thread as new community members tend to share answers and add knowledgeable responses regularly.


Reply