This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I would like to convert my data that is in EST to UTC incorporating the day light savings.I used DateTimeToUTC(),but I dont get get the desired ouput as there is no option to mention the timezone of the input data
The workflow assumes the data is in local time when it is run (so if it's running on a server, it's the time zone of wherever the server is located.) As such, you'll need to make the conversion either manually to UTC, or to local time first and then use DateTimeToUTC(). Something like the following if the input data is in central time:
If your data crosses multiple timezones, you'll likely need to use some sort of IF statement to give an integer to each time zone as it varies from UTC, and then use that in the above statement. Feel free to post some sample data if you'd like help with it.
This gives me the hours my system is currently off from UTC by comparing my current local time (DateTimeToday) to the UTC equivalent current time. This simply relies on my computer to be current with daylight savings changes.