Datediff Function

[Guest]

Perhaps this is really basic, but I cannot find any postings relative to it,
so I will go ahead and ask. I have code that follows:

DateDiff("m", #1/8/2005#, Now())

Now() is 01/04/2006

The function yields 12 which I don't expect until 01/04/2006. I expect the
function to yield 11 until then. Do I need to go to days? What am I missing?

 

[Allen Browne]

DateDiff("m"...) ignores the days, and only looks at the months. If both
months are January, it considers the dates to be 12 months apart.

If you want somthing the gives more granularity, this might help:
http://www.accessmvp.com/djsteele/Diff2Dates.html