Forum Discussion

Coryanthony's avatar
Coryanthony
Helper III
3 years ago

Time zone conversion (please help)

Hello, I am looking to convert Central Time zone to Jamaica (GMT-5) time zone.  Jamaica time does not observe day light savings. During winter, it is Eastern Time zone, during summer it is Central t...
Need Help
  • Coryanthony's avatar
    Coryanthony
    Helper III
    3 years ago

    will this account for day light savings? Data is currently in Central time zone, while Jamaica is 1+ hr ahead during winter and same time during summer.

    Thank you for the response.

  • Coryanthony's avatar
    Coryanthony
    Helper III
    3 years ago

    Bmejia 

    will this account for day light savings? Data is currently in Central time zone, while Jamaica is 1+ hr ahead during winter and same time during summer.

    Thank you for the response.

    • Bmejia's avatar
      Bmejia
      Super User
      3 years ago

      I don't believe it will, cause you adding the hour or time manually . The only way that it would probably work is if you had a date and time, you could use this, then extract the time.

       

      0 is the time zone you want to changed to.
      =DateTime.AddZone([MyDateColumn],0)

      • Coryanthony's avatar
        Coryanthony
        Helper III
        3 years ago

        Thank you Bmejia 

        i can go back a few steps. So if i have date and time together, i can create a new column using =DateTime.AddZone([MyDateColumn],0) ?