Magic ETL

Magic ETL

Why doesn't the Date Settings feature in Magic ETL update my dates?

When I navigate to Settings and change the Timezone to America/Los Angeles, it doesn't change any of the values for my date columns.

Screen Shot 2023-05-22 at 8.16.13 PM.png

However, when I navigate to my input dataset in the ETL and change the time zone on an individual date field, it works as expected.

Screen Shot 2023-05-22 at 8.16.51 PM.png


Am I doing something wrong?

Answers

  • @travorhouse Is the time zone for your instance the same as the time zone in your dataset?

  • @MichelleH, It’s supposed to be, yes. I changed the dataset timezone to other timezones such as UTC and it still fails to update it dataset wide. However, when I click on my input in the Magic ETL and adjust the timezone there, it adjusts the date fine.


    this option is fine, it just means that every time I bring in a new date field that I will have to remember to change the timezone.

Welcome!

It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign In