Calcul age from date of birthday

[#1]

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.

[#2]

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.

[#3]

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.

[#4 · Accepted solution]

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.

[#5]

Perfect. Thank you.

I have the beginning but not the end.

[Separate question] : When you have finished an analyse (Khi2 for example) ; which interface did you use for the layout like scientific article ?]