If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Dynamic date selection

Started by Kid_in_Cognos, 08 Dec 2017 03:34:19 AM

Previous topic - Next topic

Kid_in_Cognos

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

superdesi

How about default selection and then put a range.  In the properties section.

Kid_in_Cognos

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