How to load excel dates into DataTable via DataShuttle

Neil Egsgard
Neil Egsgard ✭✭✭✭✭
edited 03/13/23 in Add Ons and Integrations


I am trying to load dates from an excel file into DataTable using DataShuttle. The excel file is an attachment on a Smartsheet sheet. DataShuttle is configured to load the date field as a date. I am able to load the date values into DataTable but DataTable does not recognize these values as dates. I also tried the Smartsheet support recommended mm/dd/yyyy.

How do I configure the excel file so DataTable will recognize the dates?



Excel format

DataTable settings

DataTable data

DataTable filter results