Converting Date Time to UTC from time zones that I don't reside in.

[mark22579]

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.  

[Raj]

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)

[mark22579]

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.   

[cjaneczko]

Does the date in the file include the timezone?

[mark22579]

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.