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
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 655 Datasets
- 114 SQL DataFlows
- 2.2K Magic ETL
- 811 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 80 App Studio
- 45 Variables
- 771 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 77 Workflows
- 23 Code Engine
- 36 AI and Machine Learning
- 19 AI Chat
- AI Playground
- AI Projects and Models
- 17 Jupyter Workspaces
- 409 Distribute
- 120 Domo Everywhere
- 279 Scheduled Reports
- 10 Software Integrations
- 142 Manage
- 138 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive