Working Out Age from Date of Birth 2

[janedane]

CR 9.2

Hi All,

I need to work out the Age from the Date of Birth. AT the moment I am doing a
DateDiff("YYYY",DateofBirth,CurrentDate)
But That is not completely correct. If the are born in Dec 00 and it's Jan 04 it says that they are four years old. Has anyone done this before??

Any help would be greatly appreciated!!!

Jane

 

[goranm]

Hi !

I have a formula that I use.

I think I have found it here on Tek-Tips, but have no idea from who.

if month({table.birthdate}) < month(CurrentDate) or
//Had their birthday earlier in the year
(month({table.birthdate}) = month(CurrentDate) and
(day({table.birthdate}) <= day(CurrentDate)))
//Had their birthday earlier this month
Then
year(CurrentDate) - year({table.birthdate})
else
year(CurrentDate) - year({table.birthdate}) -1

/Goran

 

[BobSuruncle]

Truncate((DataDate - {table.birthdate})/365.25)



Bob Suruncle

 

[synapsevampire]

Bob: Doesn't work

Jane: For an accurate age, try Ken Hamady's formula:

http://www.kenhamady.com/form06.html

He used to participate here quite often and is one of the strongest people around in Crystal.

-k