Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2002
    Posts
    59

    Unanswered: How to find the difference between to dates in different rows?

    Hi everyone...

    That's my report
    Date..............Carriage No
    12/06/2006..........2864
    09/06/2006..........2862
    26/06/2006..........2862
    05/06/2006..........2862
    08/06/2006..........2860
    29/05/2006..........2860
    01/06/2006..........2859
    02/06/2006..........2857
    28/06/2006..........2856
    14/06/2006..........2856
    13/06/2006..........2855
    02/06/2006..........2814

    So I would like to find date difference between same carriage numbers.
    For Example 2862, how many days between first and second, second and third entry but I'd just skip if there is only one entry as 2859.

    Thanks
    Cuneyt
    Last edited by cuneyt; 10-03-06 at 12:33.

  2. #2
    Join Date
    Mar 2006
    Location
    south jersey, usa
    Posts
    53
    query a recordset for a specific record number.
    if the rowcount is one, skip. use recordset.getrows with ubound
    save date for a record
    compare that date to the next record
    repeat until finished.
    "They say Moses split the Red Sea
    I split the blunt and rolled the fat one, I'm deadly"
    -- Tupac 'Blasphemy'

Posting Permissions

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