Name Date Action -------------------------------- John 01/01/2005 Y John 01/03/2005 T John 01/04/2005 F I need to transform these records to : Name Date Date2 Action --------------------------------------------- John 01/01/2005 28/02/2005 Y John 01/03/2005 31/03/2005 T John 01/04/2005 / / FThe date of next record will be the date2 of current record.