Print Page - Next 7 days of data

Title: Next 7 days of data
Post by: srivenu on 13 Nov 2012 11:56:48 AM

Hi,
I have date prompt on prompt page.

For ex:

If I select Oct 1 to Oct 30 on the date prompts ( from date and to date), the repor has to show the data from Nov 1st to Nov 7th.

The query has to take the Todate (Oct 30) and add 7 days to it and gives the results. I tried several ways to add this in detail filters of the query and didnot work. Can someone please help?

Title: Re: Next 7 days of data
Post by: Lynn on 13 Nov 2012 12:50:16 PM

Maybe something like this will work for you:

[YourDate] between _add_days( ?ToDate?, 1 ) and _add_days( ?ToDate? , 7 )

Title: Re: Next 7 days of data
Post by: srivenu on 13 Nov 2012 01:30:44 PM

Thank you Lynn. Appreciate your help.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: srivenu on 13 Nov 2012 11:56:48 AM