Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2002
    Location
    Rochester, NY
    Posts
    3

    Question Unanswered: Days difference between consecutive dates

    Hi,
    I have a database table which contains a datefield and a device number. For each device there are many date entries. I want to calculate the days difference between each pair of consecutive dates for each device. Can any help me on how to write a query for this without doing programming ?

    e.g.
    deviceNnumber dates
    1 7/3/2002
    1 8/5/2002
    1 10/6/2002

    Thanks in advance.
    Hasan

  2. #2
    Join Date
    Jun 2002
    Posts
    33
    Try using the DateDiff function

    Bye
    PacuIonut

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •