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

Previous Day Filter

Started by mgregory24479, 23 Mar 2020 10:42:12 AM

Previous topic - Next topic

mgregory24479

I have a report that I need to show all transactions for the previous day but I need to factor in the weekends. So I run it today, I want it to show Friday's data but tomorrow I want to show todays. I know I need to create a filter that looks at day of week and then create a between, but I am lost. Any help is appreciated.

mgregory24479

Found the resolution

(_day_of_week(current_date,1) = 1 and [Date] = _add_days(current_date,-3)) or (_day_of_week(current_date,1) =2 and [Date] between _add_days(current_date, -3) and _add_days(current_date, -1)) or [Date] = _add_days(current_date,-1)