using current date to select parameters of automated report

[funkmonsteruk]

i have a BO report which runs on automatically on a sunday evening and is a summary of data created throughout the week.

The conditional field is called <created> and i would like the report to include records with a created date of within the last seven days. I currently run the report manually and insert the required date in a promt as the document opens.

Is it possible to add some vba code that will automatically insert this date as being seven days before the document is opened, thus automating it?

Any help will be gratefully accepted

 

[PAULSGS]

Do you actually need VB code? Could you not refer to the system date?

In an Oracle environment I could use the clause


select ....
from ...

where records.created > sysdate -7


I compare the &quot;created&quot; date with the date seven days before that in the system clock - in your case always a Sunday's date.

 

[promero]

The equivalent on DB2 is
[tt]
CURRENT DATE - 7 DAYS
[/tt]
Use that instead of the @Prompt or @Variable