datediff problem

[Guest]

I am using Datediff function to calculates how many months are between dates.
But I have found that the function only counts the months and not the actual
dates.
e.g. 1/24/06 and 2/4/06 will yield 1(one) even though it is really 0(aero).

I use Int(Datediff("d", xdate, ydate) / 30). However, this isn't really
that accurate when Feb and the months with 31 days are considered. Any other
suggestions would be appreciated.

Mike

 

[Rick Brandt]

I am using Datediff function to calculates how many months are
between dates. But I have found that the function only counts the
months and not the actual dates.
e.g. 1/24/06 and 2/4/06 will yield 1(one) even though it is really
0(aero).

I use Int(Datediff("d", xdate, ydate) / 30). However, this isn't
really that accurate when Feb and the months with 31 days are
considered. Any other suggestions would be appreciated.

Mike

DateDiff() counts "boundaries crossed" so 1 is the correct response for
DateDiff("m", #1/24/06# , #2/4/06#).

What result are you looking for? How many whole months or do you want to round
at the mid-month? Often with DateDiff you have to return a smaller increment
than you want and then do some more math on that.

 

[Guest]

Check this link for another Date diff function

http://www.accessmvp.com/djsteele/Diff2Dates.html

 

[Guest]

I am looking for the correct value between two dates.
e.g. a one(1) would be returned for dates #1/24/2006# and #2/24/2006#

Mike