AGE CALCLULATION

[Fred Beck]

CAN SOMEONE GIVE ME AN IDEA OF WHERE TO START?
I WANT TO CONVERT A DATE FIELD IE 02-14-1981 TO CALCULATE THE NEAREST BIRTHDATE IE "19"

[Ohlen Cartmell]

RE: AGE CALCLULATION

Search this forum for age birthdate. You'll find several ways of calculating the age from the birthdate. It'll get you started.

[Stan Mathews]

RE: AGE CALCLULATION

You go guy!

[JerryBrightbill]

RE: AGE CALCLULATION

Here is a age function that gives a age based on todays date.

function Age as N(DateVal as D)

years = val(left(cdate(date()),4))-val(left(cdate(DateVal),4))
if val(right(cdate(date()),4))>=val(right(cdate(DateVal),4))
age = years
else
age = years - 1
end if

end function

If you need to find an age at a certain date (how old were they on Jan 10, 1999), then you would have to add another input value in the function to use that data rather than todays date (date())

Jerry

[Leon Brachman]

RE: AGE CALCLULATION

I think the most accurate was of subtracting dates is to convert both dates to Julian (the number of days since some particular standardized starting date).

You do this with the JDATE function.

For example, JDATE(date()) gives the Julian value for today.

For 4/8/02, the JDATE value is actually 2452373.

If the variable is birth (defined as a date), then:
JDATE(date()) - jdate(birth) gives the age in days.

If you want the actual age to date in years:
int(JDATE(date())-JDATE(birth))

If you want the age to nearest year:
round(JDATE(date())-JDATE(birth)),0)

(I hope I got all the parentheses matched up.
But you get the idea.)

Leon Brachman
[email protected]

[Leon Brachman]

RE: AGE CALCLULATION

Typo correction !!
6th word above should be "way", not "was".

Leon Brachman

[Mike Konoff]

RE: AGE CALCLULATION

The following works for me.

INT(((DATE()-DOB)/365.25))

DOB = a date field for Date of Birth.

Mike

[JohnZaleski]

RE: AGE CALCLULATION

INT(((DATE()-DOB)/365.25)) will not be accurate all the time if the date you are checking is on someone's actual birthday. You can check this by seeing the age when the dob is 04/08/1956 or 1957 or 1958 or 1959 and you are calculatingthe age on the date of 04/08/2002.

Jerry's method will always work. Leap years are not a factor.