Setting default date @prompt

[Former Member]

I have a @prompt filter like this:

Table.Datecolumn >= @Prompt('Start Date ','D',,mono,free) and

Table.Datecolumn <= @Prompt('End date','D',,mono,free)

I like to set the start date defaulted to '07/01/2009'..so that user need not enter any start date as it is already shown in the prompt display.

Any help?

[Former Member]

Hi,

If you are using BOXI R2 then try like this

Table.Datecolumn >= @Prompt('Start Date ','D',{'07/01/2009'}

,mono,Constrained/Free) and

Table.Datecolumn <= @Prompt('End date','D',,mono,free)

Please appreciate if this is useful.

Cheers,

Suresh Aluri.

[Former Member]

Hi,

Try to modify your filter expression like this:

Table.Datecolumn >= @Prompt('Start Date ','D',,mono,free,,{'2009/07/01'}) and
Table.Datecolumn <= @Prompt('End date','D',,mono,free,,{'2009/07/01'})

Be careful taht the default value syntax matches the database date format.

This syntax works only for BOE XI 3.1 and upper versions.

Regards,

Didier