[AccessD] Age calculation function

Gustav,

  Are you saying 14 and 31 are correct or incorrect?  I would think they are
correct.  If so, using DateDiff with "m" and dividing by 12 will work.   I
think you're saying those values are correct, but if not, I'm confused.

Mark Whittinghill
Symphony Information Services
612-333-1311
mwhittinghill at symphonyinfo.com
----- Original Message ----- 
From: "Gustav Brock" <gustav at cactus.dk>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Friday, August 01, 2003 7:38 AM
Subject: Re: [AccessD] Age calculation function


> Hi Mark
>
> You may wish to look up "Age Calc" in the archives around Okt. 2002.
>
> Many of the "smart" suggestions will fail for date intervals like:
>
>   #03/01/1988#, #03/01/2002#
>   is 14
>
>   #03/01/1968#, #02/28/2000#
>   is 31
>