Clean up a complex date/time field

I need to clean up a date/time field so that Tableau can read it as a date field type.

In Excel I can use the following formula to clean up the formatting of the source date field:

=TRIM(CONCATENATE(MID(A7,9,2)," ",MID(A7,5,3)," ", RIGHT(A7, 4)))

Is it possible to do the same with a calculated field in Tableau?

Thank you!