First, the slider/calendar object does have that pop up calendar (you will see an icon next to the right side of the listbox) so configured properly will allow you to select only one value or multiple values, in the properties of the object. You also have Inpuboxes you can store in variables and then make selections based on that, but basically is the same thing.
Second I'd recommend you to create a master calendar as it is explained in the developer course, so you will have all your values in that table and the user will be able to select any of the dates.
Hi Miguel, Thanks for the swift response.
I have already created the Master Calendar and understand that ok.
I know that the slider/calendar object has the pop up, but what I was wondering was is it possible to have a Text Box for inputing the value of the startdate variable for example, as well as having the calendar Pop up beside that which can populate the text box? The drop downlist of all dates in the master calendar is a bit unweildy.
Lastly - How do I filter the data on the selected dates?
Do you use the ID of the object that is selecting the date in the LOAD statement?
LET vDate1 = SL01;
LET vDate2 = SL01;
ENQUIRY AS ENQUIRY_ID,
Where OPENEDDATE >= $(vDate1) AND OPENEDDATE <= $(vDate2);
Select * FROM CORPDEV."CTS_ENQUIRY_SUMMARY"
Where SL01 and SL02 are the ID's of the two slider/calendar options.
You needn't set the variables in the script, although you can do that. Anyway, you will populate those variables from the calendar object itself. Right click properties -> General tab -> Data -> Variable. That means the value you select will be stored dynamically in that variable. This way is out of the script, once you have loaded data.
If what you are looking for is how to filter loading from date to date, there is no other way that to set manually those dates, either in variables or in literals, depending on how are you loading (directly from your datasource, as in your example).