How to format time to a USA timezone without having to change after daylight savings changes?

  • 1 November 2022
  • 2 replies

I would like to display the current time in a USA timezone within an email sent by workflow. Is there a way to format the current time to a timezone without having to change the code when daylight savings changes the time 2x a year?


Best answer by SteveBarnard 7 November 2022, 18:25

View original

2 replies

Badge +4

I would recommend that you externalize the date calculation to SQL. This is the easiest method of doing this calculation. Basically going to be a stored procedure that returns a time based on a specified timezone.

Sample here :

Thanks, Steve. That's what I ended up having to do...