[AccessD] Age calculation function

Is there a solution to this?

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 2:29 PM
Subject: Re: [AccessD] Age calculation function


> Hi Bobby
>
> > This function can be made even more generic by passing in the month,
day,
> > year, and day fraction (or the day as a fraction 12/4/2003 6:00AM would
be
> > 12, 4.25, 2003).  This way, the function can handle years BC.
>
> > Just in case anyone cared.  :-)
>
> Well, could be interesting ... who knows, but it still fails an
> example like this:
>
> ? (Greg2jd("03/01/1992") - Greg2jd("03/01/1987")) / 365.25
>  4,99931553730322
>
> like any other method relying on dividing by 365,25. This method is
> what we call a "shoemaker method" as it is a method working in "most
> cases" but not all.
>
> This is not to pick on you - because it is still published many places
> - but for the records, so no list member should be tempted to use a
> quick and dirty suggestion for serious use.
>
> /gustav
>
>