#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2011
    Posts
    2
    Rep Power
    0

    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.
  2. #2
  3. SQL Consultant
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2003
    Location
    Toronto Canada
    Posts
    27,027
    Rep Power
    4210
    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.
    r937.com | rudy.ca
    please visit Simply SQL and buy my book
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2011
    Posts
    2
    Rep Power
    0
    thanks posting all new to me

    column names
    Client_No from FClient table
    tdVisit_ActualDate from TDLacVisit table

    Thanks
    Imran

IMN logo majestic logo threadwatch logo seochat tools logo