We're self learning cognos 11 currently and trying to work out how to use an advanced filter for last fiscal week. We run Sunday-Saturday and would want to always show last week no matter what day we run the report on
Hoping that I am not actually doing someone's homework. You can try the following expression:
[Date]> _add_days(current_date,-_day_of_week(current_date,7)) and [Date]<=
_add_days(_add_days(current_date,-_day_of_week(current_date,7)),7)