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?

 

 

 

 

ScriptingRe: Date Calendar box

I figured this out right after I posted this question !

 

This is what I did

 

NumberEdit1<NumberEdit2<

show(sd);
startdate=format (sd, "ddMonyyyy");

show(ed);
enddate=format (ed, "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

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

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