Skip to main content
Solved

How to change the timezone correctly?

Z
Forum|alt.badge.img+7
  • zerem
  • Known Participant
  • 17 replies

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!

 

Best answer by Soly

zerem wrote:

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

View original
    Did this topic help you find an answer to your question?

    5 replies

    S
    Forum|alt.badge.img+13
    • Soly
    • Inspiring
    • 44 replies
    • December 19, 2022
     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! 👍

    Z
    Forum|alt.badge.img+7
    • zerem
    • Author
    • Known Participant
    • 17 replies
    • December 19, 2022
    Soly wrote:
     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?

     

    S
    Forum|alt.badge.img+13
    • Soly
    • Inspiring
    • 44 replies
    • Answer
    • December 19, 2022
    zerem wrote:

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

    Z
    1 person likes this
    • Z
      zerem
    Z
    Forum|alt.badge.img+7
    • zerem
    • Author
    • Known Participant
    • 17 replies
    • December 19, 2022
    Soly wrote:

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

    S
    1 person likes this
    • S
      Soly
    S
    Forum|alt.badge.img+13
    • Soly
    • Inspiring
    • 44 replies
    • December 19, 2022
    zerem wrote:

    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


    Most helpful members this week

    Terms & Conditions