Extracting time from a date field
Hi, I'm using Data Shuttle to import an Excel file that has a combined date/time.
Smartsheet/Data Shuttle is recognizing the date, and bringing the field in as only the date. I've tried bringing it in to both date and text columns, same result. I've tried importing manually into Smartsheet (not using Data Shuttle) and same result.
Because there are multiple occurrences on the same date and times vary I've got to capture that info.