Help

Re: How to change the timezone correctly?

Solved
Jump to Solution
1398 2
cancel
Showing results for 
Search instead for 
Did you mean: 
zerem
6 - Interface Innovator
6 - Interface Innovator

Hi dear friends.
I would appreciate your help regarding time differences.
The clock should be +2 as you can see in the picture but for some reason when I do the formula it takes me back 2 hours and I couldn't figure out how to use the timezone formula.
I would appreciate your help on how to write the formula correctly so that it works.
Thank you!

zerem_0-1671435345314.png

 

1 Solution

Accepted Solutions
Soly
7 - App Architect
7 - App Architect

@zerem ,change the formula this way for your table :

DATETIME_FORMAT(SET_TIMEZONE({date created},'Asia/Jerusalem'),'HH:mm')

That should do the work, let me know if you still get the error. 👍

See Solution in Thread

5 Replies 5
Soly
7 - App Architect
7 - App Architect
 Hi @zerem !🖐
 
To fix this you need to set the time zone identifier corresponding to the one you are currently in.
So add the following formula to make yours work : SET_TIMEZONE([date], [time zone_identifier])
Your time zone identifier can be found in this article : 
 
It will look like this in your formula field . Replace Europe/Paris with your own time zone identifier to have the desired output.

 

DATETIME_FORMAT(SET_TIMEZONE({Time},'Europe/Paris'),'HH:mm')

 

I hope this helped you! 👍

zerem
6 - Interface Innovator
6 - Interface Innovator

hey, i am trying this but keep getting Error - 

any idea why?

zerem_0-1671442590275.png

 

Soly
7 - App Architect
7 - App Architect

@zerem ,change the formula this way for your table :

DATETIME_FORMAT(SET_TIMEZONE({date created},'Asia/Jerusalem'),'HH:mm')

That should do the work, let me know if you still get the error. 👍

zerem
6 - Interface Innovator
6 - Interface Innovator

wohoo

thank you Soly - how can I study the formulas at the best way?

Awesome! I'm glad you managed to get the result you wanted! 🎉👍

The best way I found so far is to read the formula field reference daily and try them on my projects.

https://support.airtable.com/docs/formula-field-reference

There is also a great table that is already set up and that you can copy to your workspace, it is called Formula Playground. When you click on creating a personal copy, it goes straight to your airtable workspace. You can find it within the article Formula Field Reference above  :

formula field.JPG

I really hope these resources will be helpful to your projects and turn you into a formula expert in no time @zerem  !😉👍 🚀