Convert ID Number to Age

Can someone please assist me with a formula to extract age from an Id no. An example is 8802074656085. The first two digits represent year i.e 1988. the third and fourth numbers represent month i.e February. the 5th and 6th numbers represent a day.

<rant>I consider "ID numbers" that have "syntax" an abomination. Just consider that in your case you have only two digits for the year - that's the very definition of the Y2K bug. And I'm willing to bet that the rest of the ID number (4656085) has parts with separate meanings - at least one of which is too short for future cases where you have more of whatever than will fit in that number of digits.

Never, ever define an "ID number" this way. Create ID numbers that are just that - sequential numbers - and that are the Primary Keys of a table that contains separate fields for each separate piece of information.
</rant>

This is only a response to Michael's rant about the format of the id number and not an answer to the question. It is not always a choice made by the database designer.

South African IDs have this same 13 digit format:
Year month day, gender, citizen or not, checksum

Every inhabitant has to have an ID number issued by the government in this format. This is used in every sphere of life in South Africa. We have no choice but to use this format to identify individuals. I assume that as this has been working for 50 plus years that the possible problems have not yet occurred.
I have had to analyze a few hundred thousand ID numbers to ensure that they are valid and this format with the checksum works very well.
Regards
Anne

What happens when two or more children of the same sex are born on the same day in South Africa ... ?

How is that number unique?

> Date: Wed, 5 Mar 2014 17:47:20 -0500
> From: email@removed
> To: email@removed
> Subject: RE:[access-l] Convert ID Number to Age
>
>
>
> This is only a response to Michael's rant about the format of the id number and not an answer to the question. It is not always a choice made by the database designer.
>
> South African IDs have this same 13 digit format:
> Year month day, gender, citizen or not, checksum
>
> Every inhabitant has to have an ID number issued by the government in this format. This is used in every sphere of life in South Africa. We have no choice but to use this format to identify individuals. I assume that as this has been working for 50 plus years that the possible problems have not yet occurred.
> I have had to analyze a few hundred thousand ID numbers to ensure that they are valid and this format with the checksum works very well.
> Regards
> Anne
>

Although I fully agree with Michael's rant and the issue of proper design, I have sympathy for the poor programmer who probably had no control over the situation. He probably inherited this database project or has the ID Numbers provided to him in a data source. Therefore the rant should not be directed at the OP, but rather at the Bozos who created the wacky ID Numbers in the first place. (I can't speak for Michael, but my guess is that was his intention.)
To pull this wagon back on the trail, let's agree that WE sometimes have to play the cards we are dealt, and sometimes a poor design is outside of our control. The OP has a situation to deal with and it looks like Michael and A Chang both came up with workable solutions. My preference is to pluck the characters out of a string with a Mid() function, but either way could work. OP - Have you tested these yet? Could you please tell us what worked for you?
Thanks,
Marvin M