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

[AHSlater]

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 solution]

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 solution]

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-relea... 

[alexnajm]

That is cool @jrgo - I did not know that! Looking forward to upgrading soon

However, it seems like it doesn't account for daylight savings well - DateTime Functions. So just be mindful if you end up using this solution

[AHSlater]

Thank you both! I'll hold off on it we are actually updating at some point this quarter!