topic Re: Labeling rows as greater/less than a date with JSL in Discussions

Labeling rows as greater/less than a date with JSL

jamiesupica0 — Fri, 09 Jun 2023 23:23:37 GMT

I have a dataset with a date column formatted dd/mm/yyyy hh:mm. In my script I want to be able to set a variable equal to some date and then have the script create a new column labelling all rows as being “before” of “after” the specified date.

The workaround I’m using is to format the variable and the column in seconds but it’s not easy to read.

Is there a way to keep the dd/mm/yyyy formatting when setting the variable in the script and also have it work in a formula?

This is the script that doesn’t work:

varProcessChange = 03/20/2016 00:01

colCondition = New Column (“Condition”)

<<data type (character)

<<Modeling Type (“Nominal”)

<<Set Formula (If(:Event Date < varProcessChange, “Before”, “After”)

Re: Labeling rows as greater/less than a date with JSL

txnelson — Sat, 25 Feb 2017 03:29:01 GMT

Here is a script that is very similar to what you want to do

Names Default To Here( 1 );
dt = open("$SAMPLE_DATA\Time Series\Raleigh Temps.jmp");
varProcessChange = Date MDY( 6, 1, 1980 );
Eval(
	Eval Expr(
		colCondition = dt << New Column( “Condition”,
			character,
			numinal,
			formula( If( :name( "month/Year" ) < Expr( varProcessChange ), "Before", "After" ) )
		)
	)
);

Re: Labeling rows as greater/less than a date with JSL

jamiesupica0 — Sat, 25 Feb 2017 19:49:00 GMT

Thanks so much, that did the trick!