Share your ideas for the JMP Scripting Unsession at Discovery Summit by September 17th. We hope to see you there!
Choose Language Hide Translation Bar
Highlighted
matthew_gill
Level I

Is it possible to format Date/Time or Duration to include milliseconds in a JMP Data Table?

Please excuse my naive question.

I have a large dataset from a temperature logger which is sampling several times per second.  I would like to format the time column to be able use the milliseconds data.  Further, in other data, Durations and Times may include milliseconds, nanoseconds, microseconds etc, but I can see no way to format the column appropriately in JMP so that these values may be used as times/durations.

Is it possible to set up a Custom Format to account for time data including durations of less than a second, and if so, how would I go about doing this?

Matt

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
txnelson
Super User

Re: Is it possible to format Date/Time or Duration to include milliseconds in a JMP Data Table?

Except for a couple of cases, JMP date/time functions deal in whole seconds.  The Today() function is a prime example.   However, you can use the HP Time() to get measurements in milliseconds, or Tick Seconds()  to get 60th of a second times.  The main issue here is that the values returned for these 2 functions are measured since the start of the JMP session.  But that can be worked around by setting a global variable to the start time of your JMP session, and then doing an offset.

Concerning the displaying of inputted values that have data in milliseconds,  you can specify decimal places for the time formats

12474_pastedImage_3.png12475_pastedImage_4.png

Jim

View solution in original post

3 REPLIES 3
Highlighted
txnelson
Super User

Re: Is it possible to format Date/Time or Duration to include milliseconds in a JMP Data Table?

Except for a couple of cases, JMP date/time functions deal in whole seconds.  The Today() function is a prime example.   However, you can use the HP Time() to get measurements in milliseconds, or Tick Seconds()  to get 60th of a second times.  The main issue here is that the values returned for these 2 functions are measured since the start of the JMP session.  But that can be worked around by setting a global variable to the start time of your JMP session, and then doing an offset.

Concerning the displaying of inputted values that have data in milliseconds,  you can specify decimal places for the time formats

12474_pastedImage_3.png12475_pastedImage_4.png

Jim

View solution in original post

Highlighted
matthew_gill
Level I

Re: Is it possible to format Date/Time or Duration to include milliseconds in a JMP Data Table?

Thanks Jim: reformatting to use decimal places is just the trick for the data logger.  It is obvious now you point it out.  I am sure I will be able to work around the microseconds etc issue (after all, that is really an issue of units more than anything).

Highlighted
kage
Level II

Re: Is it possible to format Date/Time or Duration to include milliseconds in a JMP Data Table?

If you have a time format from your data logger like this

"mm/dd/yyyy hh:mm:ss:dd" 

JMP seems to trip up on that last ":" not being a "." 

This formula snippet converts the string to a date time format via the Informat() function and then uses the decimal place field per txnelson

 

Informat(
	Left( :Time, Length( :Time ) - 4 ) || "." || Right( :Time, 3 ),
	"mm/dd/yyyy hh:mm:ss"
)

 

JMPCapture.PNG

Article Labels

    There are no labels assigned to this post.