Timezone Conversion in ETL

Figauro
Figauro Member
edited February 17 in Ideas Exchange

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. 

Tagged:
10
10 votes

· Last Updated

Comments

  • 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.