783695_en-US

liliconcom

New Character Column Based on Date Range

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!

Basic Data Analysis and ModelingRe: New Character Column Based on Date Range

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

Re: New Character Column Based on Date Range

Via the GUI, you can use Custom Binning:

and use custom labels:

 

To adjust the settings, use

Re: New Character Column Based on Date Range

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

 

Cesar

 

Re: New Character Column Based on Date Range

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