display datediff

[haytatreides]

ok, i ahe a report, and i have records with a time open and time close. i want to display the difference in the Detail section of my report, so that each record displayed gives the difference. i tried =datediff("h",[field1],[field2]) but it doesn't work. what gives?

hayt

 

[haytatreides]

nevermind.....what i actually need is the format for minutes....
m months
d days
? minutes

hayt

 

[SgtJarrow]

I believe minutes is n

****************************
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
MCSA, CNA, Net+, A+
w: rljohnso@stewart.com
h: wildmage@tampabay.rr.com

 

[haytatreides]

yeah, i just got it. I'm just trying to total the difference at the end of the report now. was going to check the forums to see if anyone has done it before. if anyone knows how...give me a post...i give stars


hayt