I can't seem to find a clear answer as to what is happening here, so I'm turning to the community.
- I have a dataset with a timestamp field,
createdAt
- The dataset arrives to Domo in UTC, and my company timezone settings are converting it to USA\Eastern Time. This is working as expected.
- Using this as an input dataset in MagicETL, I get the same expected timestamps.
The fun begins, however, when I change the field to Date on the input step (Input Dataset tile > Configuration > Data Handling > Column Type
Despite the timezone settings configured to inherit, I now get a date of 2024-11-12, rather than the 2024-11-11 it should be (see first screenshot). No matter what timezone I pick, I always get 2024-11-12.
What on earth is going on here?