Determine localised time of user during scheduled event
For each user our application we would like to perform certain actions each night at 12 o'clock. We support users from different time zones. Our idea is to schedule an event to run hourly. Every hour the microflow looks for users for which it is 12 o'clock. The planned actions will than only be executed for those specific users. We have already noticed that the system.timezone table has an attribute rawoffset that might me useful but than we have to find out if DST is applicable at the current time. Is there a way to convert the current time into the localised time of a given user?
In the community commons module you have the executeMicroflowAsUser option. This way you could retrieve the current localised time of the user if you created a variable which you fill with the current date time.
I would like to gain more knowledge in Mendix. Whats the best approach?