355973_en-US

liliconcom

Calcul age from date of birthday

Hello,

 

I readed "JMP 15 documentation helps" but not found the answer, in addition of multiple searchs on the forum community.

 

I know it's easy : how calculate the age with the date of birthday ?

 

I tried : "DifferenceDate(DateBirthday, "Today", "Year")"

 

Thank you to take one minute for a beginner.

Data TableRe: Calcul age from date of birthday

Was there any message in the Log window?

The JSL scripting index will also help. The column formulas are actually tiny JSL scripts, and you can use any functions from the scripting index.

 

Re: Calcul age from date of birthday

You need to use the Today() function.

 

Date Difference( :Birthday, Today(), "Year", "actual" )

Notice I've also added the "Actual" alignment argument to Date Difference() to get age as we usually think of it.

Re: Calcul age from date of birthday

Thank you Graige !

 

I didn't use the script because I can't use code to script.

 

I really beginner, but it's good to know.