I have attached a QVW explaining my problem. I have created two variables v_date1 and v_date2 which I set when a values is selected from Calendar objects.
I also have a CALENDAR table present in datamodel that have monthly data present.
What I want is that when I select a date range from Start date and End date calendar, the corresponding year months should get selected from list box.
I thought of creating a trigger on variable v_date1 but couldn't able to generate list of selected months to provide in search string.
I want the CALENDAR table values to get select so that I can use it as a Date Island in my application.
