Best Of

We've got a bit of a toolchain between some of our data and Domo:

Database --> Library --> Excel --> Workbench --> Domo

According to the Domo Excel Connector docs, Domo can handle a bunch of date, time and datetime formats automatically:

mm/dd/yy
dd-month-yy
weekday-month,dd,yyyy
m
m-dd
hh:mm:ss PM
hh:mm
mm/dd/yy hh:mm PM

So far, having no luck with datetimes. Pure dates can come in as dates, pure times can come in as times - but datetimes aren't making it in properly. They're either strings or numbers, not datetimes. To simplify testing this, I've abbreviated the path of the data to:

Excel --> Domo

I figure that if I can get this working, I can sort out how to do it back in our full environment.

Is there a way to set up an Excel worksheet to hold datetime values that Domo can interpret directly without any kind of transformation? The docs say that it's possible but, If not, I guess I'll use a Custom Date Format transform in Workbench instead of a DataFlow or Beast Mode to avoid any confusion in Domo with two different data sets. (We'll never need to chart with the badly interpreted datetime values.)

Thank you!