Weird Age Calculation

[tanyalee123]

Hi all, I'm trying to create an age field using the birthdate, but the birthdate is in the following format yyyymmdd, and everything I try, I get an error. I should have switched the birthdate around when I loaded in the date to read better, but now I have over 100,00 records, so that ship has sailed lol.



So I just want to put an age field in the user's main form so they can see the actual current age. I also want to use it to show actual age when they run reports, so I would use it in queries as well.

Thank you,
Tanya
Happy Friday!!

Note...this is what I've used in other databases, but I don't know how to make it work with this particular birthdate.
Age: DateDiff("yyyy",[BirthDate],Date())+(Date()<DateSerial(Year(Date()),Month([BirthDate]),Day([Birthdate])))

[June7]

So this data is in a text field? Will have to use string manipulation functions to rearrange the date parts.

Assuming the date values are all 10 characters, like: 2000/03/07

DateSerial(Left([BirthDate],4), Mid([BirthDate],6,2), Mid([BirthDate],9,2))

[tanyalee123]

Yes its a text field, but there are no slashes or dashes - 19971231

[June7]

Okay, then adjust the Start argument for the Mid functions.

[tanyalee123]

Thank you, as always!!