3 Replies Latest reply: Dec 26, 2012 4:54 AM by raj sharma RSS

    Duplicate checking

      Hi,

       

      i have do check duplicate records but condition for with in 7 days

       

      like ex1

       

      Issuedate, TicketNo,Cname

      26/12/2012,T1,Johan

      27/12/2012,T2,Johan

      28/12/2012,T3,Johan

      29/12/2012,T4,Johan

      30/12/2012,T5,Johan

      31/12/2012,T6,Johan

      01/12/2012,T7,Johan

       

      ex2

      Issuedate, TicketNo,Cname

      26/12/2012,T1,Rj

      27/12/2012,T2,Rj

      28/12/2012,T3,Rj

      29/12/2012,T4,Rj

      30/12/2012,T5,Rj

      31/12/2012,T6,Rj

      01/12/2012,T7,Rj

      02/12/2012,T8,Rj

       

      for ex1 we have to check ticket generation but for ex2 we dont need to check because there is greater then 7 Issuedate

       

      please help for this.

       

      Thanks