Converting a Date from imported data which is in Plain Text to a date field to use with "include Timeline Filter" in dashboard

Converting a Date from imported data which is in Plain Text to a date field to use with "include Timeline Filter" in dashboard

HI All

I have data that in being imported from an external application and all the dates are being imported as strings. I need a way to change or create a new colum based on the date passed in so that it can be used in a dashboard using the control "include Timeline Filter"



I have tried to change the data type to date but it errors on import and removes all the dates

This is the date from the import


The error i get on  import is



Thanks