That's the calculation to parse a valid date from your text:
d = yourSourceField ;
Middle ( d ; 3 ; 2 ) ;
Middle ( d ; 5 ; 2 ) ;
2000 + Left ( d ; 2 )
You can create a new date field and use Replace Field Contents: calculated result with the above formula to fill it.
1 of 1 people found this helpful
Thanks very much!!! This works perfectly!!