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
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 296 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 99 SQL DataFlows
- 611 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 717 Beast Mode
- 52 App Studio
- 40 Variables
- 671 Automate
- 171 Apps
- 448 APIs & Domo Developer
- 45 Workflows
- 7 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 118 Manage
- 115 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 104 Community Announcements
- 4.8K Archive