Vista - Getting elapsed time in minutes

Hi - have a snippet that finds elapsed minutes between 2 date properties of
object instances in an event log where event 20 occurs 1st and event 4 occurs
2nd:

If objItems.EventCode = 4 AND objItems.LogFile = "Application\" AND
objItems.SleepTracker = "Not Processed\" Then
endsleep = trim(objItems.TimeHolder)
For Each objItems2 in colItems
If objItems2.EventCode = 20 AND objItems2.SleepTracker = "Not
Processed\" Then
startsleep = trim(objItems2.TimeHolder)
SkipCount = 1
End If
Next
TimeDiff = cstr(DateDiff("N\",startsleep,endsleep))
objItems.SleepCount = TimeDiff
objItems.Put_
End If

TimeDiff should always return a positive number of minutes since the 1st
event is always a 20 event that precedes a 4 event. TimeHolder is a time
holder value for events. However, I am getting negative numbers for quite a
few of them.

Assuming the 20 event always precedes the 4 event, is there a reason I would
get negative elapsed minutes? Is there an issue wrapping around dates with
DateDiff in minutes? Any other known stumbling blocks with DateDiff?

TIA.

"wellsnet" <wellsnet@xxxxxx> wrote in message
news:8C3D49EE-6884-4E2B-BD98-92F661E5B799@xxxxxxI don't believe there any issues with the DateDiff function. The best
explanation is that endsleep is less than (before) startsleep. Also, I've
never seen "N\". Shouldn't it be "n"?

--
Richard Mueller
MVP Directory Services
Hilltop Lab - http://www.rlmueller.net
--