Domo changes date on its own with Excel connection
I'm having a bit of trouble with using the Excel connector to pull in data from a spreadsheet.
The first column I have in the spreadsheet contains a date. Each row represenst the start of a week. For the spreadsheet in question, the first date listed in the sheet is 5/23/2016. The next would be May 30, 2016, and so on. When I use the Excel connector, however, Domo will move each of the dates back by one day. So the first date listed within the Domo dataset is May 22, 2016.
Why is Domo doing this? And most importantly, how can I prevent it?
0
Comments
-
Does your Excel column secretly have a timestamp in the data? That can sometimes have unexpected consequences.
Aaron
MajorDomo @ Merit Medical
**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0
Categories
- All Categories
- 1.4K Product Ideas
- 1.4K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 282 Workbench
- 3 Cloud Amplifier
- 4 Federated
- 2.8K Transform
- 86 SQL DataFlows
- 548 Datasets
- 2.2K Magic ETL
- 3.2K Visualize
- 2.3K Charting
- 544 Beast Mode
- App Studio
- 26 Variables
- 566 Automate
- 134 Apps
- 411 APIs & Domo Developer
- 21 Workflows
- DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 345 Distribute
- 87 Domo Everywhere
- 257 Scheduled Reports
- 1 Software Integrations
- 85 Manage
- 84 Governance & Security
- 8 Product Release Questions
- Community Forums
- 41 Getting Started
- 27 Community Member Introductions
- 81 Community Announcements
- 4.8K Archive