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


      


Reply via email to