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

travorhouse
travorhouse Member
in Magic ETL

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?

Tagged:

Answers

  • MichelleH
    MichelleH Coach

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

  • travorhouse
    travorhouse Member

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

Categories