Difference in time

[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]

 

[Stefan Hoffmann]

hi,

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]

You can exactly do this kind of substraction. Otherwise you may take a
look at the DateDiff() function.



mfG
--> stefan <--