Calculate age in query (Access 2000)

Topic

New Reply

I use Access 2000. In a query I set up a field to calculate the age of an individual using the following expression: Age: DateDiff(“y”,[Member DOB], Date())/365.25 I received the answer in years but with 10 decimal places. How can I get the answer in simply years?

Reply | Quote

Replies

As you don’t need the decimals, use Int(DateDiff(“y”,[Member DOB], Date())/365.25)

Reply | Quote

Actually you should be using “yyyy” as the “Interval” argument in the DateDiff function … not “y”.
The “y” argument returns the “Day of Year”.

Here is an expression I always use:

DateDiff(“yyyy”, DOB, Date) + (Date < DateSerial(Year(Date), Month(DOB), Day(DOB)))

HTH
RDH

Reply | Quote

Francois thanks for the help!

Reply | Quote