User Community
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • DownloadSemiconductor Toolkit: Tools to create wafer maps, add wafer geometry to graphics, explore die defects & compare wafers.
  • Discovery Summit 2026: Early User Edition - September 23-24.Register. It's free.
  • See how to access JMP Marketplace - and - find, create & share add-ins to extend your JMP. Watch video.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
carloaz
carloaz
Level I

date format conversion

Yesterday (38 views)

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 

0 Kudos
2 REPLIES 2
jthi
Super User jthi
Super User

Re: date format conversion

Yesterday (34 views)  |  Posted in reply to message from carloaz 08-05-2026

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

-Jarmo

Recommended Articles