Solved

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

  • 1 November 2022
  • 2 replies
  • 59 views
L

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?

icon

Best answer by SteveBarnard 7 November 2022, 18:25

View original

2 replies

S
Userlevel 1
Badge +5
Hi

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 : https://stackoverflow.com/questions/36393742/using-at-time-zone-to-get-current-time-in-specified-time-zone
L

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

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings