date calculation

[#1]

Hi,

In Excel, I use the date function to get the date (d/m/y) from the year and the day of year (ex.: =DATE(2025;1;32)  .

How can I get the same formula in JMP? 

regards

[#2]

This function will return the date from the year and the day of the year.

Names Default To Here( 1 );
yd_date = Function( {year, day}, {default local},
	dat = Format( In Years( year - Year( 0 ) ) + In Days( day ), "d/m/y" );
	Return( dat )
);
the_date = yd_date( 2025, 75 );
//"16/03/2025"

[#3 · Accepted solution]

Some combination of date functions most likely  JSL Syntax Reference > JSL Functions, Operators, and Messages > Date and Time Functions . For example

Date DMY(1, 1, 2025) + In Days(32 - 1)

or

Date Increment(Date DMY(1, 1, 2025), "day", 32 - 1, "start")

[#4]

Hi,

thanks for your answers.

I use this formula: 

Date DMY(1, 1, 2025) + In Days(32 - 1)

thanks for all these informations.

regards

[#5]

There is a handy utility in this addin by @brady_brady : Special formula columns > Custom date formula writer

https://community.jmp.com/t5/JMP-Add-Ins/Data-Table-Tools-Add-in/ta-p/28582