New Character Column Based on Date Range

[#1]

Hi Everyone,

New to JMP here.  I have a Date/Time table where I would like to establish a conditional new column that if the date is > 1/1/2024, then return a character of "After."  If this is not met, return "Before."  I have tried the formula editor but still having issues.....just blanks in the rows.

Thanks!

[#2 · Accepted solution]

Assuming your DateTime column is a numeric JMP DateTime column the below formula will work

If( :Event Date < Informat( "01/01/2024", "m/d/y" ),
	"Before",
	"After"
)

[#3 · Accepted solution]

Via the GUI, you can use Custom Binning:

and use custom labels:

To adjust the settings, use

[#4]

@txnelson provided the formula. In this case, you do not need to call the In Format() function. You can use a convenient literal date value.

If( :Event Date < 01Jan2024,
	"Before",
	"After"
);

[#5]

Thank you very much both!  There is so much power in JMP.....I am really looking forward to learning more!

Cesar