2 Replies Latest reply: Jan 17, 2014 11:47 AM by Marc Van Rie RSS

    Expression Date



      Could somebody tell me which expression I have to use te make the difference between 2

      dates in workdays ?


      Thanks in advance.



        • Re: Expression Date
          Gysbert Wassenaar

          Use the networkdays function


          networkdays (start:date, end_date {, holiday})

          Returns the number of working days (Monday-Friday) between and including start_date and end_date taking into account any optionally listed holidays. All parameters should be valid dates or timestamps.



          networkdays ('2007-02-19', '2007-03-01') returns 9 

          networkdays ('2006-12-18', '2006-12-31', '2006-12-25', '2006-12-26') returns 8 

          firstworkdate(end_date, no_of_workdays {, holiday} )