Razzak, Thanks. That's a nice function, I had forgotten about it.
The true age calculation is still hard to get perfect. Feb 28th and 29th are the same day for birthday calculations. (or feb 29th and March 1st are the same) I you are born on Feb 28th how old are you on the 28th and 29th of a leap year? Or if you are born on the 29th then are you one year old on Feb 28th or March 1st of the next year? Good fodder for a discussion! Dennis -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of A. Razzak Memon Sent: Friday, November 07, 2008 1:18 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Calculating a persons age. At 02:02 PM 11/7/2008, Dennis McGrath wrote: >There is no simple way to handle leap years. Did you know that you can use the new "Is Leap Year" DATE function to handle such exceptions? New "ILY" Date function checks to see if the year portion of a given date is a leap year or not. Example: SET VARIABLE vIsLeapYear = (ILY(.#DATE)) The function returns a 1 if the year is a leap year, and 0 if it is not a leap year. Keeping this new R:BASE date function in mind, do what you need to do to achieve your goal. Very Best R:egards, Razzak.
