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
-Jarmo