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