Select Date from Datatable with different datatypes

Help
1

I’m trying to select dates > today for a specific column. However, the column MAY or MAY NOT be in datetime format (read from an Excel file). For example below:

ColumnName
15/12/2018
29 March 2019
19Mar-20Mar
3/5/2019
12 June 2019

If today is 1 May 2019, I’d only expect the last 2 dates to be picked out. There are also many other columns apart from this one, so building a datatable isn’t too feasible.

Is there a Select() Function that includes somewhat of a TryParse so that the String values (eg. 19Mar-20Mar) formats are ignored?

PS. I’ve used the Filter DataTable Activity too, but it isn’t working as expected. Excel read some dates as DateTime, while others aren’t, even though they are in the dd/MM/yyyy format. Hence the DataTable does not select those rows which may fulfill the criteria of date > today.