This is not a trick question! I need the age at the start of the UK TAX year
to calculate their pension contributions for the following year,
contributions are based on age bands - If I get this wrong I've got 3,000
factory workers out to kick my butt when they can't afford to retire!!
David Tod Sigafoos wrote:
>
> 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: u2-users@listserver.u2ug.org
>>
>> 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
>> u2-users@listserver.u2ug.org
>> To unsubscribe please visit http://listserver.u2ug.org/
> -------
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
>
>
--
View this message in context:
http://www.nabble.com/-UV--Calculate-age-from-date-of-birth-tf3023501.html#a8401999
Sent from the U2 - Users mailing list archive at Nabble.com.
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
