Google Sheet Connector and date formats
Has anyone else experienced recent issues with date format issues related to google sheets? We have several google sheet data sources that have worked well for months, but recently have stopped working(in the last 14 days). Support has yet to respond to my inquiry, so I'm hoping someone here knows something.
Here's a sample of a timeclock report with three date/time columns. The first two are date and time, and the thrid column is a duration calculation (not calulated in sheets, it's already calculated in the report and is copied to the sheet).
The same data previewed on Domo- the first two columns have the correct date, but no time. The third column comes through with a default date (totally wrong) and no time.
We have two other google sheet data sources with similar issues. I have tried many standard and custom formats to the data in google sheets and have not found any that succesfully cure the issue. I have also tried a completely fresh google sheet with new data and I'm finiding the same results.
I feel confident that it is a Google Sheet or Google Connecter issue becasue I have copied the same data to an Excel sheet and imported it to Domo with success (other than the UTC adjustment).
Thanks in advance,
Comments
-
Would anyone be able to help with this query?
0 -
I have exact same issue....
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 298 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 54 App Studio
- 40 Variables
- 678 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 46 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 33 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive