926749_en-US

liliconcom

Creating a column and Filling all rows by a date and time

I Want to create a column named, say, :CHANGE and then fill all rows by a date in the format 01/15/2026 7:02:26 PM. How do I do that. 

For some reason JSL does not recognize this format

Automation and ScriptingBasic Data Analysis and ModelingRe: Creating a column and Filling all rows by a date and time

In my opinion only reliable way to format your dates to specific format in JMP (while keeping them as numeric) is to use Format Pattern

Names Default To Here(1);

dt = New Table("Untitled",
	Add Rows(7),
	Compress File When Saved(1)
);

dt << New Column("CHANGE", Numeric, Continuous, Format("Format Pattern", "<MM>/<DL><DD>/<YYYY> <HH>:<MM>:<SS><AMPM>", 21, 0), Set Each Value(
	15Jan202619:02:27
));
<P><A href="https://www.jmp.com/support/help/en/18.2/#page/jmp/date-and-time-functions.shtml#" target="_blank" rel="noopener noreferrer"> JSL Syntax Reference > JSL Functions, Operators, and Messages > Date and Time Functions</A>&nbsp;</P>
<P><A href="https://www.jmp.com/support/help/en/18.2/#page/jmp/numeric-formats.shtml#ww953202" target="_blank" rel="noopener noreferrer"> Using JMP > Set JMP Column Properties > About the Column Info Window > Numeric Formats</A>&nbsp;</P></AMPM></SS></MM></HH></YYYY></DD></DL></MM>

Re: Creating a column and Filling all rows by a date and time

Can't thank you enough for this. Thanks