topic Re: Date Calendar box in Discussions

Date Calendar box

B1234 — Fri, 09 Jun 2023 16:56:14 GMT

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?

Re: Date Calendar box

B1234 — Wed, 06 Apr 2022 14:14:52 GMT

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

Re: Date Calendar box

pmroz — Wed, 06 Apr 2022 14:47:29 GMT

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

pmroz — Wed, 06 Apr 2022 14:54:38 GMT

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

Craige_Hales — Wed, 06 Apr 2022 15:07:13 GMT

Re: Date Calendar box

B1234 — Mon, 11 Apr 2022 06:58:54 GMT

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