Datediff Function

  • Thread starter Thread starter Yvette
  • Start date Start date
Y

Yvette

How do I get this fuction to NOT round off to the nearest
hour????? in ACCESS 2000 (I'm tring to obtain exact total
hours)

I've tried:

DateDiff("m",[startdate],[enddate]))/60
or
DateDiff("nn",[startdate],[enddate]))/60

These do not work!!

I've also tired:

DateDiff("h",[startdate],[enddate])

This rounds to the nearest hours, and I need the exact
hours.
 
Yvette;

DateDiff("n",[startdate],[enddate]))/60

this will give hours to the nearest 1/60 of an hour. Make sure that the
field/control isn't formatted as an integer.

Jim
 
Back
Top