COGNOiSe.com - The IBM Cognos Community

Hello Everyone,

I have a requirement where we have two Date Prompts,by default displaying current date.
Instead Users want to display Date values as per db i.e Minimum date value as "From_Date" and Maximum date value as "To_Date" and remaining date values should be disabled/Greyed out.
Is there a way to display(min & max dates) and grey out remaining date values in Date prompts?

Note:Using Cognos 10.2.2  RS

thanks in advance

Quote from: chinnucognos on 29 Mar 2016 08:49:37 AM
Hello Everyone,

I have a requirement where we have two Date Prompts,by default displaying current date.
Instead Users want to display Date values as per db i.e Minimum date value as "From_Date" and Maximum date value as "To_Date" and remaining date values should be disabled/Greyed out.
Is there a way to display(min & max dates) and grey out remaining date values in Date prompts?

Note:Using Cognos 10.2.2  RS

thanks in advance

Hi,

If all other dates are greyed out in each prompt, then is there any point in prompting at all? If no other selections can be made, why not just code a filter?

MF.

Hi MFGF,

Thanks for ur response..
Actually Date prompts are in Report Page with selected UI=Edit Box.
I tried with Max and Min functions to get Date values from database and placed accordingly in Date Prompt but able to select
other date values which are beyond max & min date values.Here the Dates which are not between Max & Min dates should be greyout!