2 Replies Latest reply: Oct 26, 2013 2:56 PM by AVIRAL NAG RSS

    Organization Name of Engineer Wise Holiday Count

    AVIRAL NAG

      For every "TICKET NUMBER" there comes one "CREATION DATE" and "ENGINEER COMPLETED DATE".

      I want to Calculate the Holidays Count falling between these 2 Dates for unique TICKET NUMBERS.

       

      EXAMPLE : FOR AUGUST MONTH :

       

        ORGANIZATION NAME OF ENGINEER :

       

      1) LEVEL IV DELHI            =  4 Holidays (09/08/13,15/08/13,20/08/13,28/08/13)

      2) ASF PATNA                   =  2 Holidays (09/08/13,15/08/13)

      ASF BHUBANESHWAR  =  2 Holidays (09/08/13,15/08/13)

       

      If HOLIDAY Dates falling between the Unique "TICKET NUMBER"

      "CREATION DATE" and "ENGINEER COMPLETED DATE" then Show its Holiday Count.