1 Reply Latest reply: Apr 6, 2016 12:36 PM by Stefan Wühl RSS

    Straight Table networkdays

    Andros Goh

      Hi,

       

      I tried to use networkdays in straight table, but failed as below :

       

      The field dy use previous field (FSTatusDate) and TransmDate(field created by script)

      I need to calculate the day different between FStatusDate & TransmDate (without counting week end).

       

      q1.png

       

      Thank you.

       

      Regards,

      AG.

        • Re: Straight Table networkdays
          Stefan Wühl

          Well, it would be good to see also the actual values of your expressions / fields you are using in networkdays() function.

          Or even better, could you post a small sample QVW that demonstrates your issue?

           

          In general, check that FStatusDate precedes TransmDate:

           

          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.

           

          And also double check that FStatusDate reference as well as TransmDate return a value to your expression, and only a single value:

           

          =FStatusDate & ' - ' & TransmDate

           

          Note also that one of your expressions uses TransmDate as expression label.