I have users from all over the world and I want to run an API workflow on my browser for all my users in their respective timezones (API workflow with date manipulation).
Date Manipulation Functions rely heavily on timezone when it comes to Daylight Saving Time.
For example: If you add a week to [March 8th 2019 5pm America/New_York], you will get a different absolute time if it’s executed in a US timezone browser or if it’s executed in Mexico timezone browser (because DST started in the US on March 10th 2019 but only started in Mexico a few weeks later).
One possible way to do that, is to create daily recurring workflows for every user from their browser the moment they sign up and every time the daily workflows run, they check for a binary flag that tells them if they need to execute an operation or not.
That seems like an inefficient solution and if the user moves to a new country after they signed up, I have no way to update the timezone of the workflow to the new timezone.
Any ideas how to do that differently?