Forum Discussion

619SK's avatar
619SK
Helper II
1 year ago
Solved

Timezone Conveter

I want to convert Date & Time into CST, GMT, SGT, EST, IST  timezone.

I have date columns and also created Refresh date time which should change by clikcing on Timezone.

 

 

Need Help
  • Omid_Motamedise's avatar
    Omid_Motamedise
    1 year ago

    You can use DateTimeZone.SwitchZone function, for example

    DateTime.LocalNow() leads to curent date and time at your location but the next fromula convert it to GMT (UTC+0)

    DateTimeZone.SwitchZone(DateTimeZone.LocalNow(), 0)

     


    Example for CST (UTC-6):

    DateTimeZone.SwitchZone(DateTimeZone.LocalNow(), -6)

    Example for SGT (UTC+8):

    DateTimeZone.SwitchZone(DateTimeZone.LocalNow(), 😎

    Example for EST (UTC-5):

    DateTimeZone.SwitchZone(DateTimeZone.LocalNow(), -5)

    Example for IST (UTC+5:30):

    DateTimeZone.SwitchZone(DateTimeZone.LocalNow(), 5.5)

     

1 Reply

  • Omid_Motamedise's avatar
    Omid_Motamedise
    Super User
    1 year ago

    You can use DateTimeZone.SwitchZone function, for example

    DateTime.LocalNow() leads to curent date and time at your location but the next fromula convert it to GMT (UTC+0)

    DateTimeZone.SwitchZone(DateTimeZone.LocalNow(), 0)

     


    Example for CST (UTC-6):

    DateTimeZone.SwitchZone(DateTimeZone.LocalNow(), -6)

    Example for SGT (UTC+8):

    DateTimeZone.SwitchZone(DateTimeZone.LocalNow(), 😎

    Example for EST (UTC-5):

    DateTimeZone.SwitchZone(DateTimeZone.LocalNow(), -5)

    Example for IST (UTC+5:30):

    DateTimeZone.SwitchZone(DateTimeZone.LocalNow(), 5.5)