topic Re: date format conversion in Discussions

date format conversion

carloaz — Wed, 05 Aug 2026 14:59:41 GMT

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

Re: date format conversion

jthi — Wed, 05 Aug 2026 15:18:35 GMT

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).

Re: date format conversion

christian-z — Thu, 06 Aug 2026 12:15:58 GMT

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