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.
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..