How to change the timezone correctly?

[zerem]

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!

[Soly]

 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 : 

https://support.airtable.com/docs/supported-timezones-for-set-timezone

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]

hey, i am trying this but keep getting Error - 

any idea why?

[Soly · Accepted solution]

@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]

wohoo

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

[Soly]

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  :

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