Another datediff question (I did a search already)

[t3nchi]

I have two date/time fields with a date & a time (ie. 1/1/2005 1:00 am)

I want to use the datediff function to calculate the different in hours between the 2 fields. I followed the MSDN instructions (aka datediff(h,startDateTime,endDateTime) but got an #error

How do i fix this? Thanks.

 

[t3nchi]

You'll need to post the code if you want us to fix a syntax error.

In my Control Source in a textbox in my report, this is what I have...

=DateDiff([h],[dateTimeEmail],[dateTimeEvent])

 

[t3nchi]

=DateDiff("h",[dateTimeEmail],[dateTimeEvent])

Thanks PH.