Time Zone calculation that includes day light savings for multiple time zones.

Question

I'm looking to calculate the current time difference between EST and London. I need to do this daily and to display the current time difference on a dashboard. This is to show if daylight saving is having an effect on what the normal time difference would be. I'm struggling to find a way to pull in the current time of multiple time zones in Alteryx.

alexnajm · Accepted Answer

What is your current input and expected output? Based on my understanding, either way you'll need to know the dates of when daylight savings is off/on. Or you could in theory pull these from an APi - quick google search found this: TimeAPI | A Better Way to Access Time and Timezone Information

jrgo · Accepted Answer

In the off-chance you're on, or able to upgrade to, 2024.2, Alteryx added support to specify time zones in some of the DateTime functions.

https://help.alteryx.com/release-notes/en/release-notes/designer-release-notes/designer-2024-2-release-notes.html#new-formula-functions-and-function-updates