Skip to Content
0
Jul 01, 2009 at 06:17 AM

Print Date Range

26 Views

Hello,

Database: ORACLE10g

BO Version: BOXIr3

I have created a filter in Universe named as Previous N Days and the folrmula which I placed is as follows:

@Select(Time Resolutions\Five Minutes) between (trunc(SYSDATE,'DD') - INTERVAL '@Prompt('Please enter the number of previous days to retrieve','N', {'1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','20','21','22','23','24','25','26','27','28','29','30'},Mono,free,persistent,{'30'})' day(4)) and (trunc(SYSDATE,'DD')- interval '1' SECOND)

When I will run the report with putting the above in query filter, it will ask me for number of days and data will come for the previous N days.

Now in report I want to show the From and To date. How can I show that since with a given number how can I get the dates for which data was fetched. I tried to use the SYSDATE in formula to get the dates but its not working.

Please suggest.

_________________

Thanks & Regards,

Vijesh Chandra