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. >