>>>>>See
Re: What is best way to calculate age Thread #
1155605 Message #
1155645>>>>>
>>>>>What should this class return for today and 02/29/1988?
>>>>
>>>>18 years, 6 months, and 22 days.
>>>
>>>How did you calculate that? BTW, it returns 16 days.
>>
>>It returns 18,6,22 as I stated. Are you using the latest version? This class was updated Jan. 2005. The old one may have produced a different result. See the documentation for explanation of how this class does its calculations.
>
>Am I right to go back to the person's birthday knowing his age today?
>=MESSAGEBOX(GOMONTH(GOMONTH(DATE(),-18*12),-6)- 22)
If today he/she is 18 years 6 Months and 22 days, yes, but you could use:
=MESSAGEBOX(GOMONTH(DATE(),(-18*12)-6) - 22)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.