Print Page - Schedule report and filter for the previous 7 days orders by movement date

Title: Schedule report and filter for the previous 7 days orders by movement date
Post by: cbyrne on 06 Mar 2014 10:05:00 AM

Hello i need some help with my report filter, i have scheduled a report which runs every Sunday and i want it to pickup orders booked in the previous 7 days, however because some orders are pre-booked then my report is picking up orders placed on the Monday, Tuesday etc after the report has run on the Sunday.
Do you know what teh correct filter should be that only picks up
orders placed 7 days previous? below is my current filter so the orders should cut off on the Sunday.

[Movement Date]>=_add_days(current_date,-7)

Not sure if it should instead be the below

[Movement Date]< (current_date) and [Movement Date]>=_add_days(current_date,-6)

Thanks

Chris

Title: Re: Schedule report and filter for the previous 7 days orders by movement date
Post by: Lynn on 06 Mar 2014 10:12:54 AM

Perhaps this?

[Movement Date] between _add_days(current_date,-6) and current_date

Title: Re: Schedule report and filter for the previous 7 days orders by movement date
Post by: cbyrne on 06 Mar 2014 10:39:40 AM

Thanks Lynn,

I will give this a try and let you know.

Thanks Again

Chris

Title: Re: Schedule report and filter for the previous 7 days orders by movement date
Post by: cbyrne on 06 Mar 2014 03:52:55 PM

Lynn your a genious, thank you very much that worked a treat.

Thank You

Chris

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: cbyrne on 06 Mar 2014 10:05:00 AM