AnsweredAssumed Answered

Converting text date

Question asked by KrisztianG, on Feb 26, 2013
Latest reply on Feb 28, 2013 by KrisztianG,

Title

Converting text date

Post

     Hi!

     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?

     Many thanks!

Outcomes