476648_en-US

liliconcom

Date Calendar box

I'm trying to make a jmp application that will run trends. I have two calendar boxes with a "From" and "To" date. When I click the "Run Script" button, I want to be able to use dates defined in the calendar boxes to select dates in my trend. How can I get the values from the calendar boxes to use in the script?

 

 

 

 

Advanced Statistical ModelingAutomation and ScriptingContent OrganizationData Exploration and VisualizationQuality and Process EngineeringSharing and Communicating ResultsRe: Date Calendar box

thank you @pmroz and @Craige_Hales  this was very helpful! working well now thank you both. 

Re: Date Calendar box

you might like Select Date Range with Calendar Boxes Linked calendar boxesLinked calendar boxesLinked calendar boxes

Re: Date Calendar box

Didn't realize you were using calendar boxes.  Try this:

nw = new window("Test Dates", << modal(),
 text box("Monitoring & Trending"),
 hlistbox(
  panelbox("From Date",
   cal_start = calendar box(<< Show Time( 0 )),
  ),
  panelbox("To Date",
   cal_end = calendar box(<< Show Time( 0 )),
  ),
 ),
 ok_button = button box("OK",
  startdate = cal_start << get date;
  enddate   = cal_end << get date;
 )
);

print(format(startdate, "ddMonyyyy" ), format(enddate, "ddMonyyyy" ));

Re: Date Calendar box

Try something like this:

nw = new window("Test Dates", << modal(),
 Lineup Box( N Col( 2 ),
  text box("Enter start date: "),
  start_neb = number edit box(today(), << Set Format( Format( "ddMonyyyy", 10))),
  text box("Enter end date: "),
  end_neb   = number edit box(today(), << Set Format( Format( "ddMonyyyy", 10))),
 ),
 ok_button = button box("OK",
  startdate = start_neb << get;
  enddate   = end_neb << get;
 )
);

print(format(startdate, "ddMonyyyy" ), format(enddate, "ddMonyyyy" ));

From the log:

"11Apr2022"
"24Apr2022"

Re: Date Calendar box

This is what I have tried but doesnt seem to work

NumberEdit1 << set Function( Function( {this}, sd = NumberEdit1 << Get Date() ) );
NumberEdit2 << set Function( Function( {this}, ed = NumberEdit2 << Get Date() ) );

Show( sd );
startdate = Format( sd, "ddMonyyyy" );

Show( ed );
enddate = Format( ed, "ddMonyyyy" );