How old?

[teqtaq]

I have a Birt Date of the people. I need to get their age.
What is the best formula in query for Access 2003?

Thanks

 

[teqtaq]

I got one DateDiff("yyyy",Date(),[BIRTH DATE])
but is this the best way?

 

[Remou]

Try some FAQs:

http://www.tek-tips.com/faqs.cfm?fid=3769

http://www.tek-tips.com/faqs.cfm?fid=85

http://www.tek-tips.com/faqs.cfm?fid=55

The method you show will give the same age for a person born in january and a person born in December.

 

[teqtaq]

If they both born in a same year - I am ok then.
I need to have people divided into groups 20-30, 40-50 etc.
So it should work than? Thanks for the links, I will browse.

 

[dhookom]

DateDiff() returns the number of thresholds that have occurred between two dates. This is usually not a good method for determining age. For instance:
DateDiff("yyyy",#12/31/2006#,#1/1/2007#)=1
DateDiff("yyyy",#1/1/2006#,#12/31/2007#)=1

The first dates represent a single day while second set of dates is 730 days.


Duane MS Access MVP
Now help me support United Cerebral Palsy