Changing format of numbers to date field

[InspectorJoe]

I have been given an employee data extract of 2500+ records. Each employee's birthdate is stored in the "PRDOB" field. It's data type is set to Text. The data is YYYYMMDD with no separator characters. I would like to convert this data to a new Date field "DOBedit" which recognizes this text as a Date and displays as MM/DD/YYYY.

 

[RobertT687]

You might try something like:
Newdate = CVDate(Mid$(PRDOB, 5, 2) & "/" & Mid$(PRDOB, 7, 2) & "/" & Left(PRDOB, 4))

 

[InspectorJoe]

Thanks. It worked like a charm.