My dates are all being transformed (subtracted by 5 hours) -- help!! URGENT
Comments
-
Hi all,
Can anybody help @punitfire with their situation?
Thanks!0 -
Hello @punitfire,
Looking at your company settings, It appears your timezone settings are currently set to the: "America/New_York" Timezone. This time zone is -5 Hours from UTC.
When data comes into Domo, it is assumed that this data is formated as UTC time. Domo will then convert the data's dates acording to your timezone settings. In this case the data will have 5 hours subtracted from it to account for your timezone.
From t what you mentioned, it sounds like your company timezone setting was previously set to show UTC and was changed to: "America/New_York" when you started seeing this issue.
You as an Admin user have the ability to change your timezone settings back to UTC. To accomplish this you go to your drop down tool menu > Admin > Company Settings > Company Overview > Time Zone.
If you are only seeing the time change on a single dataset you can ensure the data is coming in as UTC or we can use a dataflow to add 5 hours back onto the date columns in this dataset.
Please Let me know if this resolves the issue you are seeing. If it does not we can connect through a phone call.**Say “Thanks" by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"1 -
@punitfire, did ilikenno's reply help you out?
0 -
As previous posters mentioned, Domo expects all datetime data to be in UTC. Workbench includes a "Shift Timezone" transform to assist with this. So if your data is in EST, you would add this transform to tell Workbench that is the data timezone. Then Wb will shift it (by adding or subtracting the appropriate hours based on timezone) so that the data in Domo is in UTC. Then when Domo displays or uses the data, it will convert it for your display based on your company settings.
So it sounds like you probably need to add a shift timezone transform to your workbench job.
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 296 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive