because who's online calculates online time by subtracting the minutes, the online time is way off if someone is active before midnight and is still active after it. the code doesn't know that's the times are from two different date
strRSCheckedIn = rs("CheckedIn")
strOnlineLastDateChecked = rs("LastChecked")
strOnlineDateCheckedIn = ChkTime(strRSCheckedIn)
strOnlineLastDateChecked = ChkTime(strOnlineLastDateChecked)
strOnlineTotalTime = DateDiff("n",strOnlineDateCheckedIn,strOnlineLastDateChecked)
If strOnlineTotalTime > 60 then
' they must have been online for like an hour or so.
strOnlineHours = 0
do until strOnlineTotalTime < 60
strOnlineTotalTime = (strOnlineTotalTime - 60)
strOnlineHours = strOnlineHours + 1
loop
strOnlineTotalTime = strOnlineHours & " Hours " & strOnlineTotalTime & " Minutes"
Else
strOnlineTotalTime = strOnlineTotalTime & " Minutes"
End If
no fix for it yet though.
- Alan
www.iamviet.com
www.calvsa.net
Snitz Resource
Topic Locked
Posted - 11 July 2001 : 04:14:31
