Extracting DOB from ID Number

[lmahere]

Hi Guys,



I am trying to extract a date of birth from a South african ID number to be displayed in another field and then calculate the age which is alos dispalyed in another field. My problem is trying to extract the DOB from the 13digit ID number . The DOB is the first six numbers of the ID number e.g 8805256177085 . If anyone can help i would really appreciate it.

[cyanidem]

What format is this date? I guess in your example it's May 25th 1988? If so, then:

DOB = CDate(Mid(IdNumber, 3, 2) & "/" & Mid(IdNumber, 5, 2) & "/" & Left(IdNumber, 2))

[lmahere]

Hi Cyanidem ,

The format for the date is short date 25/05/1988 . I am quite new to Access programming , so i have only been using pass through queries as i more accustomed to SQL . Where would i enter this code ?

[rpeare]

You can use that formula to get the date of birth anywhere you need it, though primarily that'd be in queries etc then you could calculate their age based on the calculated date of birth.

[lmahere]

Thanks it worked like a charm you saved my life !!!!

[Tazmaniac]

Hi there

Curious to know if the above will work the same on a SA ID number starting with e.g. 000121... In other words will it automatically populate the date of birth as 21/01/2000?

And also if the age will calculate correct? =,18 Years?

[ArviLaanemets]

It works with 00... in case it is for year 2000, but what about people born in 1900 or 1915? How are such cases handled in RSA ID. Here in Estonia the 1st number of ID determines the century (and sex - odd for males, even for females).

[Tazmaniac]

Good question, don't know either.
I need the formula for a database I am putting together and I will never have to capture a person born before 1980.
Thanks for the reply.

[rpeare]

if you want something a little less prone to mistakes than the CDATE() function, you can also use DATESERIAL(YYYY, MM, DD) and you'll end up with a date