Days between the last 2 dates T SQL

Hi

trying to get the last two dates for a client record, and calculate the days between those dates.

basically have to visit clients every few weeks, so have multiple dates for each client

want to list both dates and then the days between

one client might have 6 visits recorded but i only want to calculate days between for the latest 2 dates.

i want my qry result to look something like this

client ID, Date 1, Date 2, days between
123, 01/01/11, 11/01/11, 10
555, 03/05/11, 28/05/11, 25
and so on

hope that make sense.

if it's T-SQL then this thread should be in the Microsoft SQL Server forum -- i've moved it for you

you should also show us the layout of your table unless you want us to guess the column names etc.

thanks posting all new to me

column names
Client_No from FClient table
tdVisit_ActualDate from TDLacVisit table

Thanks
Imran