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
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