How to load excel dates into DataTable via DataShuttle

Neil Egsgard

Hello,

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?

Thanks,

Neil

Excel format

DataTable settings

DataTable data

DataTable filter results

Danielle Wilson

@Neil Egsgard Hi Neil! I'd recommending picking this format: yyyy-mm-ddThh:MM:ssZ

But you can also change the date formatting of the field in your DataTable to match what you have in your file.