Time Zone Issues
I am new to the community. I am hoping there are suggestions.
I have a flat csv file that has a datetime field. The field is reflected correctly for my timezone, but when I import it into DOMO the system changes the time... it appears to believe my time is US-CT (which it is) but it also believes the data I am bringing in is UTC (which is not true).
Because my time zone recognizes Daylight Savings/Summer time change it isn't as simple as a +6 hours. Any suggestions out there?
Best Answer
-
Domo assumes that all times coming in are converted to UTC. Depending on where you are looking at your data, it will show it in UTC time or in the time zone set in your Company Settings.
If you are uploading your CSV file via Domo Workbench, you can use the transformation settings to move all datetime values to UTC when it uploads your data to Domo.
This KB article gives a thorough breakdown of how to handle time zone differences. You may want to look through this and see what may apply to your situation.
https://domohelp.domo.com/hc/en-us/articles/360043439073-Time-Zone-Troubleshooting-FAQ
**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.1
Answers
-
Or is it possible to tell the system that a column is NOT a timestamp but is a datetime field type?
0 -
Domo assumes that all times coming in are converted to UTC. Depending on where you are looking at your data, it will show it in UTC time or in the time zone set in your Company Settings.
If you are uploading your CSV file via Domo Workbench, you can use the transformation settings to move all datetime values to UTC when it uploads your data to Domo.
This KB article gives a thorough breakdown of how to handle time zone differences. You may want to look through this and see what may apply to your situation.
https://domohelp.domo.com/hc/en-us/articles/360043439073-Time-Zone-Troubleshooting-FAQ
**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.1 -
Thanks @MarkSnodgrass
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 297 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