Difference in time

  • Thread starter Thread starter Pass-the-Reality
  • Start date Start date
P

Pass-the-Reality

I have two fields [StartSchedule] and [StartTime]. Both fields capture time
which is formated such as 10:00 AM. How can I calculate the difference
between the two fields in my query such ast [StartSchedule] - [StartTime]
 
hi,

Pass-the-Reality said:
I have two fields [StartSchedule] and [StartTime]. Both fields capture time
which is formated such as 10:00 AM. How can I calculate the difference
between the two fields in my query such ast [StartSchedule] - [StartTime]
Click to expand...
You can exactly do this kind of substraction. Otherwise you may take a
look at the DateDiff() function.



mfG
--> stefan <--
 
Back
Top