|
View Full Version : Date Diff Problem / Please help. Jkittle 10-11-2007, 10:54 AM 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 10-11-2007, 11:02 AM 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 10-11-2007, 11:25 AM Bob, Thank you very much! Worked great. boblarson 10-11-2007, 11:29 AM Glad to hear. |