topic Re: Calcul age from date of birthday in Discussions

Calcul age from date of birthday

Mart-in — Sat, 10 Jun 2023 23:25:40 GMT

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.

Craige_Hales — Thu, 04 Feb 2021 15:16:34 GMT

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.

Jeff_Perkinson — Thu, 04 Feb 2021 15:29:17 GMT

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.

Mart-in — Thu, 04 Feb 2021 15:46:41 GMT

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.

Mart-in — Thu, 04 Feb 2021 15:50:49 GMT

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