topic Re: I want to create a column that split dates into "Before" and "After" a specific date. How is the date represented in a conditional statement? in Discussions

I want to create a column that split dates into "Before" and "After" a specific date. How is the date represented in a conditional statement?

Huw_Nanomarket — Mon, 27 Oct 2025 09:48:08 GMT

Re: I want to create a column that split dates into "Before" and "After" a specific date. How is the date represented in a conditional statement?

spyros_megalou — Mon, 27 Oct 2025 11:21:58 GMT

Hi @Huw_Nanomarket

You can use the Make Binning Formula to achieve that without the need to create a formula yourself

Select the Date Column Go Cols > Utilities > Make Binning Formula
Define the Bins Add a cutpoint for your specific date (e.g. 09-2009) Label the bins as "Before" and "After" to represent the two groups.

Click on the Make Formula Column and you are done.

Let me know if that answers your question.

Spyros

Re: I want to create a column that split dates into "Before" and "After" a specific date. How is the date represented in a conditional statement?

KasperSchlosser — Mon, 27 Oct 2025 12:27:55 GMT

In addition to Spyros answer there is also the possibility of using the "Parse Date"/"In Format" function

Date and Time Functions

or directly Writing writing the datetime.

Using dates, times, datetimes and durations in JMP

Names Default To Here( 1 );
way1 = Parse Date( "2025-10-30", "YYYY-MM-DD" );
way2 = 1Nov2025:12:30:25;

Show( way1, way2, way1 < way2 );

way1 = 30Oct2025;
way2 = 01Nov2025:12:30:25;
way1 < way2 = 1;

Kasper

Re: I want to create a column that split dates into "Before" and "After" a specific date. How is the date represented in a conditional statement?

hogi — Mon, 27 Oct 2025 12:29:07 GMT

The functionality is also available via the right click - new Formula column menu.

The advantage of using the functionality via the Cols menu:
The new column is generated with the same same format settings as the input column. When the users clicks on "Edit Binning Formula":

they can easily edit the binning:

For comparison: Edit Binning formula for a column that is generated via the new formula column menu:

[cutpoints in seconds]

Re: I want to create a column that split dates into "Before" and "After" a specific date. How is the date represented in a conditional statement?

hogi — Mon, 27 Oct 2025 12:29:28 GMT

this issue got fixed in JMP19:

Re: I want to create a column that split dates into "Before" and "After" a specific date. How is the date represented in a conditional statement?

hogi — Mon, 27 Oct 2025 12:30:44 GMT

still missing: Edit Binning Formula for Transform columns:

Re: I want to create a column that split dates into "Before" and "After" a specific date. How is the date represented in a conditional statement?

txnelson — Mon, 27 Oct 2025 13:16:54 GMT

In addition to the Make Binning Formula, in JSL you can use a simple If() comparison with dates. Here is a column formula that illustrates the how to do it

If( :Date >= Informat( "10/14/2025", "MDY" ),
	1,
	0
)

Re: I want to create a column that split dates into "Before" and "After" a specific date. How is the date represented in a conditional statement?

Huw_Nanomarket — Mon, 27 Oct 2025 14:42:16 GMT

Thanks for this. Very simple solution.