Hope this isn't a trick question <g>

Normally you will get the internal date for both birth and 'test' date
then simply subtract.  One thing to keep in mind is that anything
before 12/31/67 will be neg as 12/31/67 is day 0

so internal bdate 10/12/67 is -80 and internal test date 4/6/2006 is
13976.

In this case we want 13976 + abs -80 = 14056/4

iBdate = abs( iconv('10/12/67','D') )
iTestDate = iconv('4/6/06','D')

iTotDays = iBdate + iTestDate

iYears = int( iTotDays/4 )


*note .. the previous does not take into account leap year etc.

DSig
David Tod Sigafoos
SigsSolutions, Inc.


> -------- Original Message --------
> Subject: [U2] [UV] Calculate age from date of birth
> From: Dominion <[EMAIL PROTECTED]>
> Date: Tue, January 16, 2007 1:04 pm
> To: [email protected]
> 
> Hi,
> Could anyone tell me how I can calculate someones age from their date of
> birth at a specific point in time? ie, age at 6 April 2006 if their date of
> birth is 12 October 1967.
> 
> Thanks,
> 
> Dom
> -- 
> View this message in context: 
> http://www.nabble.com/-UV--Calculate-age-from-date-of-birth-tf3023501.html#a8398858
> Sent from the U2 - Users mailing list archive at Nabble.com.
> -------
> u2-users mailing list
> [email protected]
> To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/

Reply via email to