910187_en-US

liliconcom

Time Stamp comparison formula

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

Automation and ScriptingRe: Time Stamp comparison formula

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

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

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

Lots of information, including information about date, time, and datetime constants in Using dates, times, datetimes and durations in JMP.