Need BCA scheduled report to use "today" as input.

In my opinion then you loose functionality. In another topic here I already suggested my solution (which is also a predefined condition :lol: ):

When we have a report with prompt which is used by users as well as BCA we create double prompts like “ = Decode(@prompt(“startdate or 0 for sysdate”), 0, Trunc(sysdate), @prompt(“startdate or 0 for sysdate”))”. Users just fill in the date they want, and when it is sent to the BCA you fill in 0 and the prompt will be automatically filled.

Nick, this might be an addition for the FAQ :wink:

HenkK


HenkK :netherlands: (BOB member since 2004-03-02)