How to get Smartsheet to recognize an imported date

Paul H
Paul H ✭✭✭✭✭✭

These dates are coming from our ERP system imported via Data Shuttle, having trouble getting Smartsheet to recognize them as dates, when I try to use them in formula its always an invalid data type.

If I switch the column to text/number then back to date it recognizes them, but that's a manual process I don't want to do every time Data Shuttle uploads a new file.