Hi,
I’m on DB2 9.1 database and BO XI R2.
I got a date object, who’s SQL is :
ITM_SPL_IVT.ITM_IVT_AS_OF_TS
I have a prompt for
ITM_SPL_IVT.ITM_IVT_AS_OF_TS BETWEEN @Prompt('Start Date','D',,,) AND @Prompt('End Date','D',,,)
Now, the users are asking me to default the Start date to current day and the End Date to Week Ago.
How can i achieve that? Please help.
Thanks!
Rajani
rajani (BOB member since 2005-10-18)