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
- 10.5K All Categories
- 5 Connect
- 915 Connectors
- 250 Workbench
- 459 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 476 Datasets
- 186 Visualize
- 250 Beast Mode
- 2.1K Charting
- 11 Variables
- 16 Automate
- 354 APIs & Domo Developer
- 88 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 245 Distribute
- 62 Domo Everywhere
- 242 Scheduled Reports
- 20 Manage
- 41 Governance & Security
- 170 Product Ideas
- 1.2K Ideas Exchange
- 10 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive