Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hm, I don't see any duplicate records...
But, you can load everything except the last 7 days, and then load the last 7 days, distinct, and combine the two data sets.
Hi,
Do you present any sample for this.
Thanks
And i want to create a straight table or pivot table for this.
Thanks