Print Page - Filter for orders closed last week Mon-Sun

Title: Filter for orders closed last week Mon-Sun
Post by: trasmith on 03 Jan 2020 03:32:50 PM

Hi everyone,
I am trying to create a filter that will pull only the orders closed last week from Monday through Sunday.

Any ideas? I can't seem to find anything that works. I have been playing with the week of year function but can not seem to pull anything together.

Thank you for any support offered.

TraSmith

Title: Re: Filter for orders closed last week Mon-Sun
Post by: dougp on 03 Jan 2020 05:01:44 PM

Code Select

[Order Close Date] between _add_days (current_date, -6 - _day_of_week (current_date, 1)) and _add_days (current_date, - _day_of_week (current_date, 1))

Title: Re: Filter for orders closed last week Mon-Sun
Post by: trasmith on 06 Jan 2020 11:22:03 AM

This worked. Thank you.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: trasmith on 03 Jan 2020 03:32:50 PM