Google Sheets - Date Format issue
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?