5 Replies Latest reply: Oct 15, 2011 5:57 AM by the fourth RSS

    how to integrate a list of holidays into the Networkdays functions

    Linda Monincx

      Hi,

       

      If a source containing:

      StartDate, EndDate

      26-9-2011,3-10-2011

       

      Using the Networkdays it's coming back with 6 workdays, this is correct,

       

      I also have a tabel called Holidays containing:

      Holiday

      27-9-2011

      28-9-2011

       

      In this case the days are a tuesday and a wednesday, how can i integrate this list in the Networkdays function so that my result becomes 4 working days?

       

      attached a qvw with this data

       

      Hope this will be possible.

      Kind Regards,

       

      Linda Monincx