topic Re: New Character Column Based on Date Range in Discussions

New Character Column Based on Date Range

LEARNING — Fri, 23 Aug 2024 19:24:37 GMT

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!

Re: New Character Column Based on Date Range

txnelson — Fri, 23 Aug 2024 19:40:04 GMT

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

hogi — Sat, 24 Aug 2024 13:01:02 GMT

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

LEARNING — Sat, 24 Aug 2024 16:30:53 GMT

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

Mark_Bailey — Mon, 26 Aug 2024 12:27:40 GMT

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