Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

Calculate Exact Age

Copper Contributor

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.

3 Replies

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

Also 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