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/