Data populated from a Data Shuttle is not recognized as a date, is there a way to fix this?
I have a report that is being pulled and updated on a regular basis from a separate database. In order to bring that data into a sheet in smartsheet I have set-up a Data Shuttle. I am having an issue where one of the columns in the original excel which is meant to be formatted as a date also includes the time and timezone in the cell (see image with example of cells). Unfortunately I cannot control the format this data is pulled so this will always be in that format in he data pulls from the database. The smartsheet does not seem to read this as a date because of it. When creating the Data Shuttle the Mapping only allows me to select Auto as the Column type, I don't know if perhaps that is contributing to the issue as well. I am looking to create a report which filters based on date, but since it doesn't recognize it as a date the filter isn't working.