Hi All,

I have two prompts one is from_date and second is to_Date. My requirement is report should fetch only 4 days data.

If users entered more than 4 days , report should be no results. In case date range is <= 4 days, report should generate data. I have achieved this in query level. but how to call these two prompts in dashboard level and report level.

I have created two column prompts by using subject area and added report and prompts in dashboard. Now to build relation between prompt and report?

to_DATE(TO_CHAR(Time.Date,'DD/MM/YYYY'),'DD/MM/YYYY')>=to_date('@{Enter_date_from}{01/01/1800}','DD/MM/YYYY') AND to_DATE(TO_CHAR(Time.Date,'DD/MM/YYYY'),'DD/MM/YYYY')<=to_date('@{Enter_date_to}{01/01/1800}','DD/MM/YYYY')

and abs(cast('@{Enter_date_to}{01-JAN-1800}' as date) - cast('@{Enter_date_from}{01-JAN-1800}' as date)) <= 4

Thanks in advance,

ramesh