Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Cognos 8 Reporting - Dynamic Date Parameter

Status
Not open for further replies.

axl169

MIS
May 8, 2008
3
0
0
US
Hello,
I have created a report that has a date value in one of the fields. I want to schedule this to run on a daily basis. But have the date change dynamically with the current sysdate less 7 days. I do not know the syntax to add into the detail filters. Any ideas? Thank you in advance.
 
datefield > current_date -7

Hope this helps
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top