Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Dates and recordset problem

Status
Not open for further replies.

cm80

Technical User
May 3, 2001
85
US
Hi,
I have a problem and I have no idea how to tackle it!!!
The easiest way to explain is to give an example of what I want to do.

I have a recordset from a database with a list of dates and querystrings, eg:
1/2/01 2:33 - ball.asp
1/2/01 2:43 - egg.asp
1/2/01 1:55 - kite.asp
etc.....

What I wan't to do is have an asp page that displays the results as follows:

At 2:33 PersonA requested ball.asp.
10 minutes later PersonA requested egg.asp
12 minutes later PersonA requested kite.asp
etc.......

My problem is that I don't know how to calculate the time difference between two consecutive records.

Any help would be greatly appreciated.
Thank you
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top