Converting Date Time to UTC from time zones that I don't reside in.
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I have to convert a date time field from Berlin date time to UTC but I can't use the "DateTimeToUTC" formula because I'm in the US Central time zone. I currently have a formula to just subtract an hour and that gets me to UTC but I'm afraid that won't work during daylight savings. I'd prefer not to have to constantly adjust the formula when the time changes.
- Labels:
- Date Time
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Certainly! In Alteryx, when converting a datetime field from the US Central time zone to UTC, you can utilize the "Datetimeadd"function. This function allows you to add or subtract hours from a datetime field. Given that the US Central time zone is UTC-6 (UTC-5 during daylight saving time)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
The file dates are based off of a European time zone, not US CT. I'm looking for a way to say the dates in the file are on Berlin time, not Chicago time and then convert it to UTC.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Does the date in the file include the timezone?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
The file contains only the date & time, not the actual time zone which is CET. The IT department responsible for creating the file confirm that the date time is based off their local time in Germany. Currently I'm just adjusting the date time by subtracting an hour but that means I'd need to adjust my formula for day light savings.
