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.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 102 SQL DataFlows
- 626 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 754 Beast Mode
- 61 App Studio
- 41 Variables
- 693 Automate
- 178 Apps
- 456 APIs & Domo Developer
- 49 Workflows
- 10 DomoAI
- 38 Predict
- 16 Jupyter Workspaces
- 22 R & Python Tiles
- 398 Distribute
- 115 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 130 Manage
- 127 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 11 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 110 Community Announcements
- 4.8K Archive