Time Stamp comparison formula

[#1]

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

[#2 · Accepted solution]

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

[#3 · Accepted solution]

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")

[#4]

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.