Time Difference

[pikachew]

Hi
I need help to display the time difference in table format.
However i have difficulty in using the DateDiff("s", nowdate, olddate) function.

My table looks like this:
********************************************
<table>
<tr>
<td class="data2"></td>
<td class="data2"><%=rs("Date")%></td>
<td class="data2"><%=rs("Time")%></td>
<td class="data2"><%=DateDiff("s",rs("Time"),????)%></td>
<td class="data2"><%=sFieldName%></td>
</tr>
********************************************

rs("Time") is a recordset retrieved from the database.
rs("Time" is the current time.
However i need to retrieve the previous rs("Time") which is the previous time as shown at ????

How to i get the previous recordset object rs("Time")?
Please help.

Thanks