How do I calculate age to a specific date in the future, in Access

  • Thread starter Thread starter Tricky
  • Start date Start date
T

Tricky

I am trying to calculate members age's to various specific dates in the
future to enable me to enter members in to events on that date.
 
if you have their birthdate in a field, and the event date in another
field, you can use the datediff() function.

age = datediff("yyyy", birthdate, eventdate)
 
This method is not reliable.

Datediff("yyyy", #12/31/08#, #1/1/2009#) = 1

even though only there is really only 1 day difference.

See Daniels post for a better method.

--
HTH
Dale

email address is invalid
Please reply to newsgroup only.
 
Back
Top