How do I compute someone's age in a query

  • Thread starter Thread starter Ann Marie
  • Start date Start date
A

Ann Marie

I was wondering if anyone out there could give me the
syntax of how to compute someone's age in a query? I
tried using the datepart function, extracting the year
and then subtracting that value from the year I extracted
using the datepart function again and the now() function
for the current year. It works, however, it's basing the
age on the values of the year which isn't correct if
someones birthday is let's say in September. Here's what
I have so far:

Age: DatePart('yyyy',Now())-DatePart('yyyy',[birthday])

I must somewhere include a check on the month too. Right?
But how? THANK YOU TO ANY SOUL WHO CAN HELP ME!!!
Ann Marie
 
You can input it as below:

Age: DateDiff("yyyy", [birthday],now( ) )


Aaron _~@
Yang _`\<,_
? (*)/&(*) China Boy
~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~
 
Age: DateDiff("yyyy",Birthday,Date()) +
Cint(Format(Birthday,"mmdd")< Format(Date(),"mmdd"))
 
I was wondering if anyone out there could give me the
syntax of how to compute someone's age in a query? I
tried using the datepart function, extracting the year
and then subtracting that value from the year I extracted
using the datepart function again and the now() function
for the current year. It works, however, it's basing the
age on the values of the year which isn't correct if
someones birthday is let's say in September. Here's what
I have so far:

Age: DatePart('yyyy',Now())-DatePart('yyyy',[birthday])

I must somewhere include a check on the month too. Right?
But how? THANK YOU TO ANY SOUL WHO CAN HELP ME!!!
Ann Marie
Click to expand...

Ann Marie,
In a query:
Age: DateDiff("yyyy", [DOB], Date()) - IIF(Format([DOB], "mmdd") >
Format(Date(), "mmdd"), 1, 0)

Directly as the control source of an unbound control:
=DateDiff("yyyy",[DOB],Date())-IIf(Format([DOB],"mmdd")>Format(Date(),
"mmdd"),1,0)
 
Back
Top