COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Kid_in_Cognos on 08 Dec 2017 03:34:19 AM

Title: Dynamic date selection
Post by: Kid_in_Cognos on 08 Dec 2017 03:34:19 AM
Hi ,

In my 'From date prompt', I want to restrict the user to choose only the last 1 year date only as we have the data for only last 1 year. Can you please suggest how to achieve it?

Kind Regards,
GS
Title: Re: Dynamic date selection
Post by: superdesi on 08 Dec 2017 07:36:26 AM
How about default selection and then put a range.  In the properties section.
Title: Re: Dynamic date selection
Post by: Kid_in_Cognos on 10 Dec 2017 10:52:05 PM
Hi ,

Thank you much for your reply. I am sorry for not clearly mentioned my query.

I should have been more clearer on my request.

I will try to explain better.

we have audit data for last 1 year only. so every day it changing. If we run for today(11/Dec/2017) the last 1 year start date will be 11/Dec/2016.

If I run the report tomorrow, the last 1 year start date will be 12/Dec/2016 like that.

Then i have 2 prompts for From and To date.

So, is it possible to control the user to select the date dynamically as the 'From' date is keep changing daily?

Kind Regards,
Gowri Shankar