topic date calculation in Discussions

date calculation

Françoise — Wed, 04 Jun 2025 12:25:15 GMT

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

Re: date calculation

mmarchandFSLR — Wed, 04 Jun 2025 12:48:07 GMT

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"

Re: date calculation

jthi — Wed, 04 Jun 2025 12:48:53 GMT

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)

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

Re: date calculation

markschahl — Thu, 05 Jun 2025 07:14:29 GMT

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

Re: date calculation

Françoise — Thu, 05 Jun 2025 12:46:35 GMT

Hi,

thanks for your answers.

I use this formula:

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

thanks for all these informations.

regards