Calculating Age from DOB

[Ant]

I have a Date Of Birth (DOB) field and need to calculate the age. I have
tried “Datediff(“yyyy”,[DOB],Now())” this seams to work most of the time
however if for example you are 25 at the end of Jan this calculation will
show that you are 25 from 1st Jan. Any ideas?



Thanks

 

[Rick B]

DateDiff("yyyy",[Birthdate],Date())+(Format([Birthdate],"mmdd")>Format(Date(
),"mmdd"))

 

[Ant]

Thanks for that! I had been working on it for hours!

DateDiff("yyyy",[Birthdate],Date())+(Format([Birthdate],"mmdd")>Format(Date(
),"mmdd"))

I have a Date Of Birth (DOB) field and need to calculate the age. I have
tried "Datediff("yyyy",[DOB],Now())" this seams to work most of the time
however if for example you are 25 at the end of Jan this calculation will
show that you are 25 from 1st Jan. Any ideas?



Thanks