Forum Discussion
Linda74
Sep 20, 2023Copper Contributor
Calculate Exact Age
OK, I am driving myself crazy. I need help. I am trying to determine "clean" time of former addicts. We celebrate the amount of time they have been sober. I have a sober date listed in my DB that returns the number of months. I have tried all the date calculations I can think of. However, I would like to get the number of years, months and days updated each day. Can someone please help me figure this out? Thanks so much.
Hi,
You'll need some VBA code like this from Gustav to calculate that.
Servus
Karl
****************
Access Forever
Access News
Access DevCon
Access-Entwickler-Konferenz AEK- George_HepworthSilver ContributorAlso asked and answered (including a response with his code from Gustav) at UtterAccess.
Hi George,
Ok, even the same answer everywhere is then quite bland. Therefore here a few lines of code from myself in an Italian newsgroup in 1999. 🙂
Servus
Karl
****************
Access Forever
Access News
Access DevCon
Access-Entwickler-Konferenz AEK