Im looking for an easy way to convert dates. I am slightly anal retentive so when i import data i want all my dates to match when i print something out. here is an example:

Covert all dates from:

1 oct 1907, 1 OCT 1970, 1 October 1970, Oct 1, 1970,

to

01 Oct 1970

is this even remotely possible?