Transform date in "Tuesday 30th September 2014" format to a DD/MM/YY?

[martyn_birzys]

Without getting into messy Right() and Left(), is there a way to transform dates in string format, such as "Tuesday 30th September 2014"  to a proper date such as DD/MM/YY?

[martyn_birzys]

Anyone?

[maxgro · Accepted solution]