I have a Date of Birth field in a form named “DOB” and would like to have a Text Box next to it that calculates the age using the =Date(), Today or =Now() function. Is there a clever calculation that takes into account leap years adn also returns years and months instead of e.g. 82.89?
The calculation I have at present entered in the properties of the text Box is:
“=([now]-[dob])/365”.
This returns a nearly answer of 83.89 for a DOB of 21/5/1919. I would like 83 years and 10 months (ignoring left over weeks and days if there are any.)
Is this possible in Access 2000?