Bug / Incorrect behavior with Convert_TZ() in MagicETL
TL;DR - The covert_tz() is subtracting an additional 5 hours when trying to convert a date/time value in UTC back to its original ET.
I have a record that occurred on July 31, 2023 at 08:00:29pm, when recorded in UTC this is '2023-08-01T00:00:29.000Z'. This record has 'America/New_York' as a value in timezone
. I wanted to convert it back to the original timezone so that it was included in July's reporting. Below is my implementation within MagicETL without column names:
Convert_TZ(2023-08-01T00:00:29.000Z, +00:00, America/New_York)
That function returns: '2023-07-31T15:00:29.000Z' or July 31, 2023 3:00:29pm but all logic based on reading documentation and consulting my good friend ChatGPT says that it should return '2023-07-31T20:00:29.000Z' or July 31, 2023 8:00:29pm (which is when the record actually occurred).
I eventually got my desired result with the following code: CONVERT_TZ(completeDate
,'+00:00','+01:00')
According to the documentation at
, that previous line of code should return 2023-08-01T01:00:29.000Z.Best Answer
-
@zaclingen_zips This sounds like a mis-alignment with your instance time zone from your company settings. Does the dataflow produce any different results if you set the time zone in the Dataflow Transform settings instead?
Here is a Knowledge base article about troubleshooting time zones in Domo:
1
Answers
-
@zaclingen_zips This sounds like a mis-alignment with your instance time zone from your company settings. Does the dataflow produce any different results if you set the time zone in the Dataflow Transform settings instead?
Here is a Knowledge base article about troubleshooting time zones in Domo:
1 -
Yep, we had the same issue @MichelleH pointed out and resolved it using the same suggestion from her above.
If I solved your problem, please select "yes" above
0 -
Thanks for the feedback. I get it now.
I feel like it might be worth including that detail in the function's description within MagicETL. This isn't the first time a lack luster description in there has stirred me wrong.0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 618 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 741 Beast Mode
- 58 App Studio
- 40 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 395 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 6 Software Integrations
- 124 Manage
- 121 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive