prompt date value with default max from table1.column1

[Former Member]

Hi all,

How do I prompt user for date of report with default date = max(table1.column1) ? Give me some example of syntax pls.

Thanks ahead.

[Former Member]

hi,

Default Date for the Date Prompt can be Static but not dynamic in WEBI.

Because we can't specify any object/calculation as default value for the prompt.

I think it's not possible in WEBI.

Regards,

Vamsee