Select distinct rows based on latest date

Hi

Thanks for your reply much appreciated. It wasn't giving me exactly what I needed as it wasn't returning the latest Origination date but the one before it. By substituting the line supplied by Guoxiong that worked exactly as required.

Thanks again

John