[AccessD] Age calculation

Steve Schapel miscellany at mvps.org
Sat Jun 23 14:44:42 CDT 2007


Very nice, Gustav.

However, I can't find an example where the following does not work 
correctly.  Can you?

Age: DateDiff("yyyy",[DOB],[DateAt])+(Format([DOB]+(Format([DOB],"mmdd") 
="0229"),"mmdd")>Format([DateAt],"mmdd"))

Regards
Steve

Gustav Brock wrote:

> As I have posted several times, most of the functions published
> around the web for this simple task is crap because they fail for
> calculations around Feb. 28./29., thus they are not suited for
> business use.
> 



More information about the AccessD mailing list