Happy 8th birthday to the Maveryx Community! Take a walk down memory lane in our birthday blog, and don't miss out on the awesome birthday present that all Maveryx Community members get to take advantage of!
Our main navigation will be under construction for the next hour. "Launch Pad" will be moving to "Learn", and the "Introduce Yourself" forum will be moving to a thread in the "General" discussion.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Convert UTC to Local Time by Location

7 - Meteor

I've checked multiple posts in the community, but can't quite figure out how to do what I need.  I have orders from multiple locations, across multiple time zones, and some of the locations don't participate in Daylight Saving Time.  Yet, somehow, I need to convert the order time from UTC to local time.  Parsing out the hour from the timestamp portion is easy, I just don't know to build in all the other logic and have it work during DST and without DST.  


Order #LocationOrder DateOrder Time (UTC)Time ZoneDaylight SavingUTC to LocalConvert to DSTExpected Result
1017/15/20202020-07-15T15:00:00CentralYUTC minus 6N/A in July9
1127/15/20202020-07-15T19:00:00CentralNUTC minus 6N/A - No DST at this location13
1237/15/20202020-07-15T20:00:00EasternYUTC minus 5N/A in July15
90112/15/20202020-12-15T15:00:00CentralYUTC minus 6UTC minus 510
91212/15/20202020-12-15T19:00:00CentralNUTC minus 6N/A - No DST at this location13
92312/15/20202020-12-15T20:00:00EasternYUTC minus 5UTC minus 416


This site has a small table of Daylight Saving Time for the next few years, which might help when evaluating an order date to see if it's in DST or not.  While a dynamic solution is ideal, I'm not opposed to hard coding this table as a Text Input, since I hope my project doesn't need to exist more than a few years.



Sample data is attached.  

Thanks so much for reading and please tell your dog I said hi!


13 - Pulsar

I didn't include the DST calculation, but this is what I did : 


2020-07-16 09_52_36-Alteryx Designer x64 - New Workflow1_.png

7 - Meteor

This is great!  Thanks!

7 - Meteor

For reference, here's the final solution.