Time problem

Surjer

Registered User.
Local time
Today, 17:10
Joined
Sep 17, 2001
Messages
232
This database is for a GPS Observation Session table. What I am trying to get is the Observation span. (Length of time set on a particular point.....

What I have is a start and a stop time. Stop subtract start = span....

That works perfect untill days that the span went through Midnight

stop @ 12:19 AM - start @ 11:31:00 PM = 23:12 it should = 0:49

TIA

Jerry
 
Are you using the DateDiff function?

NetD: DateDiff('n',[field1],[field2])
 

Users who are viewing this thread

Back
Top Bottom