max datediff in a While loop

[sbbrown9924]

I am looking for the maximum date interval of
datediff("n", objRS("TriageTime"), objRS("InRoomTime"))
in a "While Not objRS.EOF" loop.

I tried this:

if datediff("n", objRS("TriageTime"), objRS("InRoomTime")) > MaxWaitingTime then MaxWaitingTime=datediff("n", objRS("TriageTime"), objRS("InRoomTime"))
end if

This is probably quite basic. Any help would be appreciated. Thanks.

 

[tsuji]

Try this which shows the idea behind if there are further complications on the data format from the rs.

[tt]if datediff("n",[red]cdate([/red]objRS("TriageTime")[red])[/red],[red]cdate([/red]objRS("InRoomTime")[red])[/red]) > MaxWaitingTime then
MaxWaitingTime=datediff("n",[red]cdate([/red]objRS("TriageTime")[red])[/red],[red]cdate([/red]objRS("InRoomTime")[red])[/red])
end if
[/tt]
Note: if what you show is all on one line, then you don't need "end if".

 

[sbbrown9924]

Tsuji - thanks for your help, you gave me a little gem of information that helped me figure this out.