Dynamically defaulting a date prompt for a Oracle stored procedure

[flowersr]

Hi,

I am trying to default a date prompt to the previous week's Sunday date for a COGNOS 8 Report Studio report that is automatically scheduled to run each Monday. It must also have the capability to use a user selected date from the date prompt when it is run on demand/interactively. The report's data source is a Oracle stored procedure where its parameter is a datetime value. Can anyone help me with a detailed explanation on how to accomplish this.

Right now it works fine with a date prompt when run interactively where user selects the date.

Thanks,
Rich