topic Re: Calendar Box question in Discussions

Calendar Box question

UberBock — Fri, 09 Jun 2023 23:41:22 GMT

When using the calendar box to allow users to select dates is there a way to set the time to a default time? The reason is I am using it let the user select a date range which is used in a SQL to query data. So if the user selects 1/1/2020 as the start and 3/1/2020 as the end they may miss data because they didnt set the time to 12:00:00 AM and 11:59:59 PM. Can the calendar box could be set to default to those times

Re: Calendar Box question

danschikore — Fri, 23 Oct 2020 17:11:55 GMT

If you initialize the calendar with a date+time but only show the date editor, the time will be remain the same when dates are selected. Here's an example that ensures that you have the full days included at the endpoints:

Names Default To Here( 1 );
result = New Window( "Calendar Box Example",
	<<Modal,
	<<OnValidate(
		fromDate = fromCal << Get Date();
		toDate = toCal << Get Date();
		1;
	),
	H List Box(
		V List Box(
			Text Box( "From:" ),
			fromCal = Calendar Box( <<Date( Parse Date( "4/2/2002 12:00:00AM", "m/d/y h:m:s" ) ), <<Show Time( 0 ) )
		),
		V List Box(
			Text Box( "To:" ),
			toCal = Calendar Box( <<Date( Parse Date( "10/14/2003 11:59:59PM", "m/d/y h:m:s" ) ), <<Show Time( 0 ) )
		),

	)
);
If( result["Button"] == 1,
	New Window( "results",
		V List Box(
			Text Box( "From: " || Format( fromDate, "M/D/Y h:m:s" ) ),
			Text Box( "To: " || Format( toDate, "M/D/Y h:m:s" ) )
		)
	)
);

Re: Calendar Box question

Craige_Hales — Fri, 23 Oct 2020 18:02:46 GMT

also see

Re: Calendar Box question

UberBock — Fri, 23 Oct 2020 18:57:06 GMT

Thank you! I can certainly use this