...or you can use INT to return an integer. Note that in leap years, the age will be one year too high on the day before a person's birthday.
Regards, Stephen Markson ForenSys The Forensic Systems Group www.ForenSys.ca 416 512 6950 > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Fitts, > David A. > Sent: November 7, 2008 1:37 PM > To: RBASE-L Mailing List > Subject: [RBASE-L] - RE: Calculating a persons age. > > Hi Jim, > > Thank you for noting the problem with my suggestion. > > The JDATE function does indeed return an integer which the Rbase > documentation says is in the format of YYYYDDD for versions 6.1a and up. > Mathematically, two JDATE results can not be simply subtracted from each > other to get a meaningful or useful result that continues to follow the > YYYYDDD format. > > I do believe that the number of whole years between two dates using the > JDATE function can yield a person's true age if used as follows: > > Set v age to (aint((jdate(.#date))-(jdate(.vbirthday))/1000)) > > Thank you for the correction, > > Dave Fitts > State of Maine > Risk Management > > > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of James > Bentley > Sent: Friday, November 07, 2008 12:06 PM > To: RBASE-L Mailing List > Subject: [RBASE-L] - RE: Calculating a persons age. > > David, > > Your solution is functionally incorrect. First, it returns an integer > which is not in the YYDDD format. Second, It incorrectly calculates the > difference between dates. See other posts for correct calculation. > > Jim Bentley > American Celiac Society > [EMAIL PROTECTED] > tel: 1-504-737-3293 > > > > ----- Original Message ---- > From: "Fitts, David A." <[EMAIL PROTECTED]> > To: RBASE-L Mailing List <[email protected]> > Sent: Friday, November 7, 2008 10:31:01 AM > Subject: [RBASE-L] - RE: Calculating a persons age. > > Can I suggest something like > > Set v age to ((jdate(.#date))-(jdate(.vbirthday))) > > This returns the age in YYDDD format so that you know how many years and > days old the person is. > > Regards, > Dave Fitts > State of Maine > Risk Management > > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Gray, > Damon > Sent: Friday, November 07, 2008 10:33 AM > To: RBASE-L Mailing List > Subject: [RBASE-L] - Calculating a persons age. > > In the absence of a DATEDIFF function, is there a function in RBase > 6.5++ that will allow me to calculate an employee's age from their date > of birth and .#DATE, or do I need to code this up? > > > > > > Damon J. Gray > > Business System Services > > Anvil Corporation > > (360) 937-0770 > > > > > > No virus found in this incoming message. > Checked by AVG - http://www.avg.com > Version: 8.0.175 / Virus Database: 270.8.6/1765 - Release Date: 11/7/2008 > 9:08 AM
