Calculate Exact Age

Question

OK, I am driving myself crazy.&nbsp; I need help.&nbsp; I am trying to determine "clean" time of former addicts.&nbsp; We celebrate the amount of time they have been sober.&nbsp; I have a sober date listed in my DB that returns the number of months.&nbsp; I have tried all the date calculations I can think of.&nbsp; However, I would like to get the number of years, months and days updated each day.&nbsp; Can someone please help me figure this out?&nbsp; Thanks so much.

karl_donaubauer · Answer

Hi George,
&nbsp;
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. 🙂
&nbsp;
ServusKarl****************Access ForeverAccess NewsAccess DevConAccess-Entwickler-Konferenz AEK
&nbsp;

karl_donaubauer · Answer

Hi,
&nbsp;
You'll need some VBA code like this from Gustav to calculate that.
&nbsp;
ServusKarl****************Access ForeverAccess NewsAccess DevConAccess-Entwickler-Konferenz AEK

george_hepworth · Answer

Also asked and answered (including a response with his code from Gustav) at UtterAccess.

Forum Discussion

Calculate Exact Age

3 Replies

Resources