1 Reply Latest reply: May 11, 2011 7:03 AM by Shubhasheesh Chakraverty RSS

    To get networkdays

      Dear Members,

       

      I want to calculate networkdays between 25-04-2009 11:01:05 to 04-05-2009 08:01:58

       

      I tried like this networkdays('25-04-2009','04-05-2009','01-05-2009')  then I got 5 working days

       

      but when I used date along with timestamp it also give 5 working days which wrong.

       

      Am doing wrong, Please give me suggestion.

       

      Thanks & Regards,

      Yogesh

        • To get networkdays
          Shubhasheesh Chakraverty

          I had this problem few days back.

          so i used networkdays as well as interval both

          like

           

          if

          (

          Interval((date2- date1), 'mm') < 0

          ,

          num((-1)*(networkdays(date2,date1) -1), '00') & ' days ' & subfield(interval(date2- date1, 'DD hh:mm:ss'), ' ' , 2)

          ,

          'DD hh:mm:ss'), ' ' , 2)

          num(networkdays(date2,date1), '00') & ' days ' & subfield(interval(date2- date1, 'DD hh:mm:ss'), ' ' , 2)

          )