COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: evapsmile on 31 Mar 2015 09:50:01 AM

Title: To make the first date and last date coulmns of a date prompt as Current.
Post by: evapsmile on 31 Mar 2015 09:50:01 AM
Hi,

I am working on report studio and I need my first date and last date properties of a date prompt(edit box) to be current values instead of static values.
I want my last date to be sysdate no matter when I run the report.
How can I make the "last date" property for that date prompt(edit box) a dynamic value ?
Is it manageable through javascript? If so can somebody please share it?
Thanks for your help in advance.

Title: Re: To make the first date and last date coulmns of a date prompt as Current.
Post by: BigChris on 31 Mar 2015 10:02:06 AM
See if this does the sort of thing you need:

http://cognostips.weebly.com/blog/date-prompts
Title: Re: To make the first date and last date coulmns of a date prompt as Current.
Post by: evapsmile on 31 Mar 2015 10:21:41 AM
Thanks Chris for your response.
I think I did not put my question right.
I just edited it again.
Title: Re: To make the first date and last date coulmns of a date prompt as Current.
Post by: BigChris on 01 Apr 2015 02:31:45 AM
Hi - do you want the user to be able to alter the end date, or do you want it to always be the sysdate?