Hi,

I want to retain the latest date when the difference between two BOD meeting dates is 1 or 2 or
Meeting_date date_diff Co_code
24-01-2012 94 11
22-05-2012 119 11
23-05-2012 1 11
09-08-2012 78 11
29-10-2012 81 11
01-11-2012 3 11
In the above instance, for example, when the date difference is 1, I want to drop 22/5/2012 and retain 23/05/2012.

Pls help me with the code for this.

Thanks