Timezone Conversion in ETL

Since most datasets are brought in at UTC time, there should be an option in the ETL to convert date/time timezones so that I can then have a proper date/time to date conversion to throw in a group by. Currently, the date/time to date will result in a UTC date which isn't helpful at all. I could add hours to the date/time, but once daylight savings hits I'd have to change all the flows and it wouldn't be correct for all date/times. 

10 votes

· Last Updated


  • We have major Timezone issues like this as well. Getting this fixed would be a HUGE plus for our Organization.

  • Always struggling with time zones as well. Even a static date field from a spreadsheet gets converted. 

This discussion has been closed.