date format conversion

[#1]

20260627 160152   

 How can I convert this date code to one wihich is preccable by JMP to do a time axis plot on x axis ?

  Carlo 

[#2]

I assume you get this as a string somewhere -> In Format() with format pattern

In Format("20260627 160152", "Format Pattern", "<YYYY><MM><DD> <hh24><mm><ss>")

This should convert it to JMP's datenum which you can then format as needed by using column properties for example. If you have the value in a column, you could try to mess with direct format pattern formatting, but using formula with In Format() is safer option (and easier to use in my opinion).

[#3]

Using dates, times, datetimes and durations in JMP - JMP User Community