Google Sheets - Date Format issue

Hi,
We are processing data on a global level and have Date fields comming in in different formats. We have 3 main formats of dates, as simulated in this google sheet (Timestamp, Date US Format and Date EU format).
Once loaded in DOMO (via the Google Sheet connector) it looks like this
As you can see the Timestamp and US Date look good, however the EU Date is loaded as a number.
Ofcourse we can manually edit the Googlesheet, however as the objective is to load these sheet automatically, we don't want manual interventions.
My question is there a setting, configuration or trick to load these dates propperly into DOMO, without changing the Googlesheet ?
In other words, can DOMO propperly read EU Date formats via Googlesheets or only US Date formats?
Thanks,
Joeri
Best Answer
-
Just as an FYI DOMO updated the Google Sheet connector and it now propperly detects the regional dates, so problem solved.
0
Answers
-
"Date EU" can be made from "Date US".
BEAST MODE: Date EU
DATE_FORMAT(`Date US`,'%e/%c/%Y')
Format rule
https://dev.mysql.com/doc/refman/5.7/en/date-and-time-functions.html#function_date-format
1 -
Thanks tomo, this is great if you have the date in both formats, what sadly isn't always the case. I made a file with the 3 different date formats, we receive as an example, so data from a EU client will contain dates in EU format, from a US client in US format.
Our DOMO instance is configured at Timezone UTC, we can ofcourse change it to CET, I suspect the import of EU Dates will then work, but the US dates won't work anymore ?
I'll reach out to DOMO support and see what we can find out, and will post the updates here, as they might be helpfull for others.
Br,
Joeri
0 -
Just as an FYI DOMO updated the Google Sheet connector and it now propperly detects the regional dates, so problem solved.
0 -
Hi Joeri,
Is there any update? I'm facing the same issue.
Thanks!
1
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
- 657 Datasets
- 115 SQL DataFlows
- 2.2K Magic ETL
- 815 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 81 App Studio
- 45 Variables
- 775 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 81 Workflows
- 23 Code Engine
- 40 AI and Machine Learning
- 20 AI Chat
- 1 AI Playground
- 1 AI Projects and Models
- 18 Jupyter Workspaces
- 410 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 10 Software Integrations
- 144 Manage
- 140 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