Views keeps converting time to UTC
Hi All,
I am having an issue with a dataset. I am trying to extract an hourly occupancy from people's entry and exit dates and time. However, Views keeps converting the times from Eastern to UTC. I have checked, and my company's time zone is already set to Eastern.
I'm not sure what to do from here. If I do an offset in a function, I would have to set up two because UTC doesn't follow DST. Then, even if it works, the dates for DST would be different every year and mess up the data.
Best Answer
-
@HowDoIDomo I'm not aware of any settings like that, but I did find a helpful formula that adjusts for daylight savings:
1
Answers
-
@HowDoIDomo I would check the timezone of the dataset used for the view. If it is not the same timezone as your instance, it may be trying to convert it.
1 -
Hi Michelle,
Thank you for checking out my question. AT first, the dataset was set to UTC in workbench and subtracted 4-5 hrs from the time, and then would add the hours back in when manipulating the data (conveniently the correct Eastern time). Then, once we updated the time zone setting in workbench, it came in without change the time, but the "hour" and "time" functions still shift 4-5 hrs depending on DST.
Is there a setting for Views that I need to toggle to specify EST?
0 -
@HowDoIDomo I'm not aware of any settings like that, but I did find a helpful formula that adjusts for daylight savings:
1 -
Thank you! This extremely helpful. I hope you had a relaxing Labor Day weekend!
0
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 656 Datasets
- 115 SQL DataFlows
- 2.2K Magic ETL
- 813 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 81 App Studio
- 45 Variables
- 771 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 77 Workflows
- 23 Code Engine
- 36 AI and Machine Learning
- 19 AI Chat
- AI Playground
- AI Projects and Models
- 17 Jupyter Workspaces
- 410 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 10 Software Integrations
- 142 Manage
- 138 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive