Help

Now () not returning correct time in UK

Topic Labels: Dates & Timezones
Solved
Jump to Solution
1113 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Matt_Lister
5 - Automation Enthusiast
5 - Automation Enthusiast

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?

1 Solution

Accepted Solutions
ScottWorld
18 - Pluto
18 - Pluto

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

See Solution in Thread

1 Reply 1
ScottWorld
18 - Pluto
18 - Pluto

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