Print Page - Filter Expression to query for last work week

Title: Filter Expression to query for last work week
Post by: Rosadocc on 24 Sep 2019 09:43:48 AM

Hi. I'm fairly new to developing reports in COGNOS Report Studio and have a question.

What is the best expression to pull a report for the previous work week (Monday thru Friday)?

For example, today is Tuesday and if I run the sales report today, I want it to show all transactions from last Monday thru Friday. The same applies to whatever day I decide to pull the report.

Title: Re: Filter Expression to query for last work week
Post by: Andrei I on 24 Sep 2019 11:01:37 AM

E.g. Filter:

[Date] between
_add_days ( current_date
, (-1) * ( _day_of_week ( current_date,1)-1 )
)
and
_add_days ( current_date
, (-1) * ( _day_of_week ( current_date,1)-1 ) +4
)

Title: Re: Filter Expression to query for last work week
Post by: Rosadocc on 25 Sep 2019 09:39:05 AM

Thanks.

I came across another expression that seemed to work for me:

[Date] between
_add_days(current_date, (-1 * _day_of_week(current_date,2)) - 7)
and
_add_days(current_date, (-1 * _day_of_week(current_date,2)) - 3)

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Rosadocc on 24 Sep 2019 09:43:48 AM