Display Numeric-Date column as "d/m/y h:m:s"?

louiefb — Fri, 09 Jun 2023 22:01:03 GMT

Hello,

I have a date-time column that I want to display as "d/m/y h:m:s", yet retain its Numeric-Date data type (as in the right table of the figure):

I have the following:

:"Time" << Data Type(Numeric);
:"Time" << Set Modeling Type(Continuous);
:"Time" << Set Format(Format("m/d/y h:m:s", 23));

But it instead converts the column onto Unix time format. How do I get this done through JSL?

Thanks,

Louie

Re: Display Numeric-Date column as "d/m/y h:m:s"?

txnelson — Sat, 19 Dec 2020 05:20:33 GMT

The issue you are having, is that you are attempting to specify the format incorrectly. The Format() function always returns a character string. Take a look in the Scripting Index for examples on how to use the Format() function.

The JSL below will convert a Character column with the data formatted as

08/21/2020 11:17:31

and convert it into a JMP Date/Time column

:Time << Data Type( Numeric );
:Time << Set Modeling Type( Continuous );
:Time << Input Format( "m/d/y h:m:s" );
:Time << Format( "m/d/y h:m:s", 23 );

topic Re: Display Numeric-Date column as "d/m/y h:m:s"? in Discussions

Display Numeric-Date column as "d/m/y h:m:s"?

Re: Display Numeric-Date column as "d/m/y h:m:s"?