Solved: Re: Calcul age from date of birthday

Report Inappropriate Content · Feb 4, 2021 10:09 AM

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.

Jeff_Perkinson · Feb 4, 2021 10:29 AM

You need to use the Today() function.

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

2021-02-04_10-24-54.665.png

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

-Jeff

Craige_Hales · Feb 4, 2021 10:16 AM

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.

Craige

Mart-in · Feb 4, 2021 10:46 AM

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.

Jeff_Perkinson · Feb 4, 2021 10:29 AM

You need to use the Today() function.

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

2021-02-04_10-24-54.665.png

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

-Jeff

Mart-in · Feb 4, 2021 10:50 AM

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 ?]

Calcul age from date of birthday