Skip to main content
Solved

Now () not returning correct time in UK

  • August 1, 2022
  • 1 reply
  • 11 views

Forum|alt.badge.img+5

Hi
So I have a formula: SET_TIMEZONE(NOW(),‘Europe/London’)
This should return the current time in London.
However it is out by 1 hour.
Currently it is 15:28 but the formula returns 14:28.
Is this because airtable is not aware of British Summer Time?
Can this be fixed?

Best answer by ScottWorld

Check your field’s formatting settings to make sure that you don’t have the GMT toggle turned on.

1 reply

ScottWorld
Forum|alt.badge.img+35
  • Genius
  • 9814 replies
  • Answer
  • August 1, 2022

Check your field’s formatting settings to make sure that you don’t have the GMT toggle turned on.