AnsweredAssumed Answered

Extracting a date from a number

Question asked by lpuis on Jan 20, 2013
Latest reply on Jan 24, 2013 by lpuis


Extracting a date from a number


     Hi all,

     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?

     Many thanks,