topic Time Stamp comparison formula in Discussions

Time Stamp comparison formula

mlo1 — Tue, 28 Oct 2025 12:21:32 GMT

I have to create an annotation column which should be filled depending on timestamp range from Time1 till time2.
What is the correct jsl function to put into the formula to compare the given timestamps with the dates in the Time column?

If((2025-10-23 00:56:57) <= :Time <= (2025-10-26 10:56:57), "Step 1")

The Time column has the following format

I am using JMP19.0.0

Re: Time Stamp comparison formula

jthi — Tue, 28 Oct 2025 12:28:12 GMT

Can Time1 and Time2 be found from somewhere? If not, you can use following format directly

28Oct2025:14:25:08

Or use Informat() and define the format

Re: Time Stamp comparison formula

txnelson — Tue, 28 Oct 2025 15:09:29 GMT

Here is how I would handle it

If(informat("2025-10-23 00:56:57", "yyyy-mm-ddThh:mm:ss") <= :Time <= Informat("2025-10-26 10:56:57","yyyy-mm-ddThh:mm:ss"), "Step 1")

Re: Time Stamp comparison formula

Jeff_Perkinson — Tue, 28 Oct 2025 15:28:41 GMT

time = 14:10:15;
date = 18Jan1957;
datetime = 11Jul2000:03:10:12;

Lots of information, including information about date, time, and datetime constants in .