Date Diff Problem / Please help.

[Jkittle]

I'm using the date diff .... DateDiff("h",[Start time],[End time]) in a query and then I report the results in a report. I have run into a problem for the first time. I had a start time of 7:00pm, and an end time of 7:00am. This was calculated in the query as (-12) which is messing up my cost formula.

How do I resolve this?

Jerry

 

[boblarson]

I'm using the date diff .... DateDiff("h",[Start time],[End time]) in a query and then I report the results in a report. I have run into a problem for the first time. I had a start time of 7:00pm, and an end time of 7:00am. This was calculated in the query as (-12) which is messing up my cost formula.

How do I resolve this?

Jerry

Use the Absolute value:

Abs(DateDiff("h",[Start time],[End time]))

 

[Jkittle]

Bob,

Thank you very much! Worked great.

 

[boblarson]

Glad to hear.