Converting multiple date formats (string) into date format

[TristanDraaisma]

Hi all,

newby in town, hope you forgive my ignorance on the subject. 

I have a data source where the date column is presented in multiple formats like this:
30/07/22
30-06-2022
30-06-2022
5/3/2022
3/31/2022
20 Jun 2020

When i import the sheet (Google sheets) the column is identified as a string and therefore i can't use the data as date which is the desired outcome. I also do not have change access to the source document. I would like convert this data into dates in Looker itself. I have tried to use PARSE_DATE but this only supports one format (as far as i can see in the documentation) I have used this option which does update some of the records PARSE_DATE("%d-%m-%Y", enddate)

Who can help me in finding an efficient way of converting this data into date formats instead of string format?

Thanks!