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

    Expression Date

      Hello

       

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

      dates in workdays ?

       

      Thanks in advance.

       

      Marc

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

           

          Examples:

          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} )