Datediff Function

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Nz function not showing all records 2
startdate, enddate to display the duration such as 0 days 01:01 1
Help with Code and Working Days including Holidays 14
Query Question 1
DateDiff ("m", StartDate,EndDate) 1
Help with my function vba code 1
Using the DateDiff function based on 5 days 12
DateDiff calculation 3

Top