3 Replies Latest reply: Sep 11, 2013 7:42 AM by Ariel Klien RSS

    NetWorkDays in the script.

    Ariel Klien

      Hello all experts.

       

      I have a table with the field  THE_DATE format 'YYYYMMDD' but it was save as string.

      I want to count network days in the script.

      how can I do that?

       

      In the chart after I load the table it is working.

      NetWorkDays(date(MakeDate(left(min(THE_DATE),4),right(left(min(THE_DATE),6),2),right(min(THE_DATE),2)),'DD/MM/YYYY'),

      MonthEnd(date(MakeDate(left(max(THE_DATE),4),right(left(max(THE_DATE),6),2),right(max(THE_DATE),2)),'DD/MM/YYYY')))

       

       

      But I want to do it in  the script level.

       

       

      any idea?

       

      BR

       

      Ariel