If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

How to Set Automated Report Based on Dynamic Date Range

Started by cogb, 29 Jan 2014 01:10:36 PM

Previous topic - Next topic

cogb

Hello:

I am trying to create a report that is scheduled to run automatically once a week on Thursday mornings and returns the records that were added from the past week only.  So, if it were run tomorrow, the desired date range would be January 23, 2014 12:00 AM - January 29, 2014 11:59 PM  This date range also needs to be displayed as text in the report.

I'm having a hard time in writing the filter (I'm assuming this requires a filter) and I can't seem to find good documentation, so I'm almost shooting in the dark.  I would appreciate any help you can give.

Thank you,
cogb

MFGF

Hi,

How about

[Your created date item] between current_date and _add_days(current_date,-7)

Cheers!

MF.
Meep!