calculating with dates 1

[zoglchaim770]

I have a table that has field [date of birth]
I need to know how old is this person
I did something like this year (date ())-year ([date of birth] it is not exacted
I would like to know his age in years and months something like: 12 years and 6 months old
could you please help me

 

[scriverb]

The following will calculate the age for you:

Int((DateDiff('d',[date of birth],Date())/365.25))

There are many threads in this forum that provide you with code to manipulate the age in years, months, and days. Look for the FAQ and Search for Age to find this code.

Good luck.



[COLOR=006633]Bob Scriver[/color]

[COLOR=white 006633]MSU Spartan[/color]

 

[dhookom]

Actually a more accurate expression is
Age=DateDiff("yyyy", [Bdate], Now())+ _
Int( Format(now(), "mmdd") < Format( [Bdate], "mmdd") )
There is a function at

http://www.mvps.org/access/datetime/date0001.htm

Duane
MS Access MVP
Find out how to get great answers faq219-2884.