Wierd Date Calculations

Steven · #1 (**permalink**) December 15th, 2003, 09:54 PM

I was just doing some date calculations, and was wondering if this happens to other people, and if so, does anyone know why.

Copy this into a module:

Code:

Function WierdThing()
Debug.Print DateDiff("n", #7/2/2003 12:15:00 AM#, #7/2/2003 1:55:00 AM#)
Debug.Print DateDiff("n", #11/15/2003 6:55:00 AM#, #11/15/2003 8:00:00 AM#)
Debug.Print DateDiff("h", #7/2/2003 12:15:00 AM#, #7/2/2003 1:55:00 AM#)
Debug.Print DateDiff("h", #11/15/2003 6:55:00 AM#, #11/15/2003 8:00:00 AM#)
End Function

The results I get are:
100
65
1
2

Which confuses me. For some reason, 100 minutes = one hour, but 65 minutes = 2 hours.

Any ideas why this happens?

Steven

I am a loud man with a very large hat. This means I am in charge

stephanel · #2 (**permalink**) December 16th, 2003, 12:26 PM

When you ask for the difference, DateDiff disregard the data inferior to the calculation interval.

So when you use this
Debug.Print DateDiff("h", #11/15/2003 6:55:00 AM#, #11/15/2003 8:00:00 AM#)
DateDiff use
Debug.Print DateDiff("h", #11/15/2003 6:00:00 AM#, #11/15/2003 8:00:00 AM#)

Stéphane Lajoie

Steven · #3 (**permalink**) December 16th, 2003, 07:44 PM

Excellent - I thought it might be something like that, and while I might not like it - at least I know what's happening, and can do a DateDiff("n" and divide it by 60 instead
Thanks Stéphane

I am a loud man with a very large hat. This means I am in charge

Need to download code?

Navigation