Calculating Age from DOB

  • Thread starter Thread starter Ant
  • Start date Start date
A

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
 
Thanks for that! I had been working on it for hours!

Rick B said:
DateDiff("yyyy",[Birthdate],Date())+(Format([Birthdate],"mmdd")>Format(Date(
),"mmdd"))







Ant said:
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
Click to expand...
Click to expand...
 
Back
Top