count of days from 2 date columns EXCLUDING SATURDAY AND SUN

[system]

hello Friends.

I have this assignment where we need to capture performance day count from the difference of 2 date columns in the report. However, the count need to exclude the weekend( sat/sun) to reflect true contractor performance. For example we have contractor PROCESSING COMPLETE DATE and then there is RECEIVE DATE. We are on DB2. Let me know of any suggestion in terms of function/formula or any insight to handle this requirement. The max difference count on the current report could be as high as 400 days.
Happy spring to all of you folks. Cheers!
Nick

---

nickbhal (BOB member since 2007-04-03)

[system]

In first step find first Sat after FROM DATE. Then find Last Sat from TO DATE. Then you have four dates, now you can calculate days as per your requirement.

---

Rakesh_K (BOB member since 2007-12-11)

[system]

This post may also help

120×120 10.4 KB

How do I calculate number of working days in a month? If an employee works for 5 days in a week, how many days he will be working in a month? Similarly, if he works for 6 days in a week, how many days he will be working in a month? Similarly, if he works for 7 days in a week, how many days he will be working in a month? So far I am able to calculate 7 working days <7 Working Days> =DaysBetween(<Month> ,<Last Day of month>)+1 kool (BOB member since 2005-04-15)

---

MBTDC (BOB member since 2007-12-28)

[system]

This post may help:

120×120 10.4 KB

I am using Business Object desktop intelligence and trying to come up with a formula to count days in between two date fields. I have two date fields say start date and end date.I need to find out the days between these two dates excluding Weekends(saturday and sunday’s). The current BO universe doens’t have a calendar table and I don’t have the rights to create a table. How can I accomplish at the report level?? Any help would be appreciated. Thanks. boboleft (BOB member since 2010-07-16…

---

David P. (BOB member since 2010-11-09)