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

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

matthew_gill — Thu, 18 Aug 2016 09:49:23 GMT

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

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

txnelson — Wed, 19 Oct 2016 03:48:01 GMT

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

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

matthew_gill — Thu, 18 Aug 2016 13:24:17 GMT

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

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

kage — Tue, 13 Nov 2018 01:38:28 GMT

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