Datediff in Access

[Cheveliar]

I am trying to calculate age. My formula reads age: Datediff("y", [birthdate],now()) I get some long number that is not even close...Am I missing something here?

 

[jebry]

Hi!

Try this:

age: Datediff("yyyy", [birthdate],now())

This will not be exact since it doesn't take month or day into consideration.

hth
Jeff Bridgham
bridgham@purdue.edu

 

[BSman]

To calculate the difference in years, the formula should read:
Datediff("yyyy", [birthdate],now())

The single Y you are using calculated the number of the day in the year.

 

[Cheveliar]

Thanks guys how stupid of me...