Default value for date prompt

[Former Member]

BO XI R2 SP1

DB: Oracle10g

Hi - I have a couple of date prompts and I was wondering if I could set default values for those prompts; for example I have Start and End date prompts; I want to set Start prompt to First Day of the current Month and End prompt to Last Day of the current Month. That will help users not to change Date fields when running monthly reports.

Please help.

Thanks!

[Former Member]

Hi Ahmed,

There is a default option in the @prompt statement. It is the last parameter into this function. This prompt could then be added to universe.

If you are doing it from WebI then when you create a query filter against your date and switch it to prompt, clicking the prompt detail will display a dialog with a number of options. One of these should be to set a default value.

Regards

Alan

[Former Member]

Hi Alan - That won't work but I'm not sure. In my understanding you can put a hardcoded default value in that parameter or you could use persistent that shows the last value used for the prompt.

I was thinking about more dynamic; for example if I run report today it should show start date: 12/01/2008 and end date: 12/31/2008 and next month when I open the same report; it should say start date:01/01/2009 and end date: 01/31/2009

Thanks!

[Former Member]

Hi Ahmed,

For that I have used a default value, for example 1/1/1900. Then the code for the condition would be

my_date = case when @prompt("Enter Date", D,....) = to_date('01/01/1900', 'DD/MM/YYYY) 
                then sysdate
                else @prompt("Enter Date", D,....) 
                end

this will return the current date if the user enters the special '01/01/1900' date.

Regards

Alan