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
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
Can't thank you enough for this. Thanks