Hal Kaplan wrote: > Why are you concerned about being a day off when all Brian's code does is > subtract the birth year from the current year. Brian's code is wrong for > every date prior to the birthdate. That is if your birthday is Nov 30, 2000, > Brian's code says you are 6 when you are really 5 for the whole year up to > Nov 30th. >
Life insurance companies in my experience say that you are 6 from the day of (or perhaps the day after) your 5th birthday until the day of (or day after) your 6th birthday when you are 7 - IOW their actuarial tables are based on age NB (next birthday) > If you are going to use Brian's "algorithm," this is much simpler .... > > age=year(date())-year(birthdate) > > > Of course, you are in the best position to judge how accurate (or inaccurate) > your calculations need to be <g> > > HALinNY > > => -----Original Message----- > => [mailto:[EMAIL PROTECTED] On Behalf Of Andy Davies > => Tom Slayton said "INT((tdDate-tdBirthDate)/365.25)" > => > => thanks Tom, I was thinking along those lines myself but > => wasn't sure that it wouldn't occasionally be a day out - I'm > => going to go with Brian Abbots suggestion. > => ( Brian Abbot said: > => INT((VAL(DTOS(dToday))-VAL(DTOS(dBirth)))/10000) ) > => > => Andrew Davies MBCS CITP > > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
