To make the first date and last date coulmns of a date prompt as Current.

[evapsmile]

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.

[BigChris]

See if this does the sort of thing you need:

http://cognostips.weebly.com/blog/date-prompts

[evapsmile]

Thanks Chris for your response.
I think I did not put my question right.
I just edited it again.

[BigChris]

Hi - do you want the user to be able to alter the end date, or do you want it to always be the sysdate?