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.
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 _______________________________________________ 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.
