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?
Answer
How to format time to a USA timezone without having to change after daylight savings changes?
Best answer by SteveBarnard
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
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
- Nintex Employee
- Answer
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
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.