4 Replies Latest reply: Oct 30, 2013 6:20 PM by Stefan Wühl RSS

    Number of Sundays :

    AVIRAL NAG

      Hi Experts,

       

      I want to count the Difference 2 Dates based on Status one is Part Request and another one is Part Sent  working on Distinct TICKETNUMBER :

       

      For eg. :

       

      TICKETNUMBER

      WORKSTATUS

      MODIFIEDON

      Sundays Coming

      CD1300000294778

      Part Request

      6/6/2013 5:53:40 PM

      1 SUNDAY coming between these 2 Dates

      CD1300000294778

      Parts Sent

      6/10/2013 3:00:57 PM

      CD1300000294778

      Part Request

      6/11/2013 5:30:23 PM

      1 SUNDAY coming between these 2 Dates

      CD1300000294778

      Parts Sent

      6/19/2013 3:13:57 PM

      CD1300000294778

      Part Request

      6/19/2013 4:49:45 PM

      1 SUNDAY coming between these 2 Dates

      CD1300000294778

      Parts Sent

      6/27/2013 4:09:48 PM

       

       

      Final Result = CD1300000294778 = 1+1+1 = 3 Sundays