Converting text date
I have ~ 9000 records imported as text in the wrong format.
Each date looks like: 2012.01.23. with a dot at the end. How can I convert these text fields to dates in the format 2012.01.23 without the dot at the and to make eg. sorting possible?