Hi ,

I have onc date column in that I have transition date for each customer.

I have to find out the difference between the dates per customer.

eg :-

CUST_ID date

XXX 12-05-2008

XXX 12-08-2008

XXX 12-25-2008

XXX 12-28-2008

If the difference between the dates (Pervious and next ) is greater than 4 then I have take the sum from the pervious date to last date.

Please suggest me the answer

Thanks and Regards,

Pravin V. Kadam