Sep 20 2023 02:56 PM
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.
Sep 21 2023 03:41 AM
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
Sep 21 2023 04:48 AM
Sep 21 2023 08:22 AM
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