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?
Page 1 / 1
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
Thanks, Steve. That's what I ended up having to do...
Reply
View our Community Site Map
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.