This is even more accurate as it takes into account leap years!!!! (INT((jdate(.#date)-jdate(.vbirthday)-idoy(.#date)+idoy(.vbirthday))/1000))
Dennis McGrath -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Dennis McGrath Sent: Friday, November 07, 2008 10:39 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Calculating a persons age. Wow Dave, That is a very slick way to handle this. I'll have to add it to my bag of tricks. Dennis -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Fitts, David A. Sent: Friday, November 07, 2008 10:31 AM To: RBASE-L Mailing List 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
