344667_en-US

liliconcom

Summarize function Date

I pretty new to jmp and have been trying to gain as much knowledge as possible on the the scripting language.  I have been referencing both the scripting guide and the index if I run into any issues.  As far as the Summarize function is concerned,  is there somethin I am missing.... I am attempting to pull the min and max date and I am getting a rather large numerical value.

As far as the formatting is concerned this is what I have..

Summarize(
 pNum = By( :Part Number ), 

 minL = Min( :Start Length ),
 maxL = Max( :Start Length ),
 massM = Mean( :Name( "Mass (g/m2)" ) ),
 sDevM = Std Dev( :Name( "Mass (g/m2)" ) ),
 minT = Min( :Time ) ,
 maxT = Max( :Time ) 
);

Data TableScriptingRe: Summarize function Date

JMP DateTime variables are numeric values based upon the number of seconds since January 1, 1904.  Therefore the actual numeric value is a very large number.  To display the value as a time value, the easiest way, is to specify a format() function.

Summarize(
 pNum = By( :Part Number ), 

 minL = Min( :Start Length ),
 maxL = Max( :Start Length ),
 massM = Mean( :Name( "Mass (g/m2)" ) ),
 sDevM = Std Dev( :Name( "Mass (g/m2)" ) ),
 minT = Min( :Time ) ,
 maxT = Max( :Time ) 
);

show( format(minT, "m/d/y h:m:s"),format(maxT, "m/d/y h:m:s"));

 

Re: Summarize function Datewhat do you mean when you say it isn't working? Without having an actual sample of your data table, I am not seeing anything of issue.Re: Summarize function Date

I am getting this error... 

Which to me doesn't make sense, in that the column was created utilizing the previous script as a numeric time column.

The data is being pulled from an SQL server.