Date change in workbench
Hi, I am using Domo workbench. When i run a data feed with a query the time seems to change when I see the data on the webpage. So for example, when I run a query and put it in workbench it is saying July 01st 00:00, however, when I look at the data on the data page it says June 31st 08:00. There is a 5 hour difference. I am not sure how to correct. Did anyone have this experience?
Best Answers
-
Agree with Michelle that you should use the timezone transformation if you actually need the time. If you don't actually need the time in your analysis, go the schema tab and change the data type from datetime to date. When it is just a date field, Domo won't try and apply any timezone shifts to that field.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0
Answers
-
Agree with Michelle that you should use the timezone transformation if you actually need the time. If you don't actually need the time in your analysis, go the schema tab and change the data type from datetime to date. When it is just a date field, Domo won't try and apply any timezone shifts to that field.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.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
- 621 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 743 Beast Mode
- 58 App Studio
- 41 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