Find difference in time between two points 1

[AHint]

Hi,

I need to find the time difference between datetime fields. DateDiff only appears to give me the days.

The data I am checking will usually be only a couple of hours difference but could potentially be a more than 24 hours. Possibly to complicate matters the second date I am comparing against (ie the later time) could be a null.

Does anybody out there know of a solution??

Thanks

 

[mrees]

You can return the difference in hours in a datediff eg

datediff(h,{mystarttime}, {myendtime}) .

As for the null end time, I would be tempted to use the currentdatetime instead (as long as you warn the user) eg.

datediff(h,{mystarttime}, if isnull({myendtime}) then currentdatetime else {myendtime})

mrees

 

[AHint]

Thanks - problem solved!