Date Column importing incorrectly (subtracting a day)
I am using the Microsoft Sharepoint Online Connector to bring in some data from an excel file. I have a date column, that for whatever reason, comes into the DOMO datebase a day earlier than what is listed in the excel document. It has also added time to the date column. I have tried lots of different date formats to see if it changes anything, but it is always different.
Comparing the data it looks like this:
Excel file:
Wednesday, December 2, 2020
Domo database:
1 Dec 2020 17:00:00 PM
Anyone have any ideas why it is doing this? I thought that perhaps it is accounting for timezones or differences? but that doesn't make sense to me.
Thanks for your help!
Comments
-
When data gets loaded into Domo it's assumed data is being sent in UTC.
Then when Domo displays the data to you, it is translated into the timezone of your "Company Settings." so if the your company was in EST the data should be 'automatically converted'.
places where people fall over is in not transmitting the data in UTC or conducting ETL in domo to adjust the timezone... which always leads to heart ache.
https://domohelp.domo.com/hc/en-us/articles/360043439073-Time-Zone-Troubleshooting-FAQ
To avoid the issue entirely, ensure that the data is being loaded as just DATE. If you have a Date column with a time component, it will assume the time is midnight, AND THEN Domo will 'help' by adjusting ?
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"1
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 59 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
- 396 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 125 Manage
- 122 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive