Cascading To Date Based on From Date

[yoursmani]

Hi,

I have a field called Mid month from table which has the value of type Mar 15, 2012 etc...
My requirement here is to have two text box prompts where i need to load the data in From Date as Mar-2012 and so on.

If for ex user selects Mar-2012 then second prompt should automatically display dates starting from Mar-2012 till Dec-2012 ( only for this particular Year 2012).

If for another ex user selects Apr-2015 the second prompt should automatically display dates starting from Apr-2015 till Dec-2015 and so on.

The requirement is basically to compare the report against different Month rages across year to see the data.

Please let me know if there is any workaround or solution for this.

Thanks,
Mani.

[R Ambre]

Hi,

I think I understood your requirement correctly.

I am not sure how to use text box prompt but I have solution for this using value prompt.

Create two different queries for two prompts which will have same Date data item
For first prompt lets say you have parameter name "p_start_date"
and for second prompt ,parameter name would be p_end_date.

You just have to add below two filters in second prompt query.

[Date] > ?p_start_date? ---- for selecting dates greater than first prompt.

--------------------------------------------------------------------------------------------
extract
(
year from
(to_date
(
to_char(?p_start_date? ,'YYYY-MM-DD')
,'YYYY-MM-DD')
)
)
= extract(year from [Date]) ----------------And to populate dates for particular year.


You can necessary modifications according to your requirement.

let me know if this works for you.