Module for time difference

[EBee]

if(rs!Tx_Time) TimeDiff(rs2!TX_Time) <1 min then
debug.print line

I am trying to compare time and check if the difference between the two is less than 1 min, if so, copy the line, and if not delete the line, go to next line

erwin

 

[MichaelRed]

if(DateDiff(&quot;s&quot;, rs!Tx_Time rs2!TX_Time) < 60)then
debug.print line
End If
MichaelRed
mred@att.net

There is never time to do it right but there is always time to do it over

 

[EBee]

Thank you, this helps to compare record and select records that only meets the criteria.

erwin