Skip to main content

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!

 

 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! 👍

 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! 👍


hey, i am trying this but keep getting Error - 

any idea why?

 

hey, i am trying this but keep getting Error - 

any idea why?

 


@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 ,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. 👍


wohoo

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

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  :

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

 

Reply


Terms & Conditions