Re: Calculating a person's age

#1

John:
this gives the number of months:
mnth = DateDiff("m", dob, Date)
if you want years and months
yrs = mnth / 12 - 0.5
mnths = mnth mod 12

Good Luck
Ira Solomon

On 1 Aug 2003 05:24:36 -0700, fishezuk (AT) btopenworld (DOT) com (FishezUk)
wrote:

Quote:

Hi

Can anybody help me please! I am trying to create a student records
database. I have a (short date) column with the date of birth and am
looking for anyone who can help me to create a column with their age
in months and years.

Any ideas/possibilities greatfully received.

Thanks

John

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Calculating a person's age

comp.database.ms-access comp.database.ms-access

Re: Calculating a person's age - 08-01-2003 , 03:50 PM