Extracting a date from a number
I have a relative easy question I believe, but I just can't get the right way to do it.
I have records containing a field that is a patient record number. It contains the reversed date of birth from the patient, eg. A720131DS00S, which means this patients' birthdate is 31/01/1972. How can I extract the birthdate and put it in the field 'Date of Birth' as a date?