October 24th, 2011, 09:04 AM
Days between the last 2 dates T SQL
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.
October 24th, 2011, 09:24 AM
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.
October 24th, 2011, 10:19 AM
thanks posting all new to me
Client_No from FClient table
tdVisit_ActualDate from TDLacVisit table