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

Exclude weekends from date filter

Started by Anon, 15 May 2024 08:30:58 PM

Previous topic - Next topic

Anon

Hi all. I have set up a schedule on a report to run for  from the earliest date of the pending orders to current date, +2 days . I am using [Date]<=_add_days(current_date,+2) in the detail filter as I am not using prompts. However, I want to exclude the weekends. Can you please help me to retrieve only the working days data? Thanks in advance.

donut

There should be a day_of_week function available. So adding onto your detail filter you would have something like
[Date]<=_add_days(current_date,+2) and day_of_week([Date]) not in (6,7)

Do check the syntax required..