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

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

NewToThis — Tue, 27 Jan 2026 20:48:10 GMT

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

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

jthi — Tue, 27 Jan 2026 20:54:55 GMT

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>/<DD>/<YYYY> <hh>:<mm>:<ss><AMPM>", 21, 0), Set Each Value(
	15Jan202619:02:27
));

JSL Syntax Reference > JSL Functions, Operators, and Messages > Date and Time Functions

Using JMP > Set JMP Column Properties > About the Column Info Window > Numeric Formats

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

NewToThis — Tue, 27 Jan 2026 21:03:44 GMT

Can't thank you enough for this. Thanks