query to tell number of months between two dates

Guest · Mar 28, 2006

is there a way to tell the number of months between 2 dates
for example

Date 1 Date 2
3/1/2006 11/1/2007 = 20 mos

Tom Ellison · Mar 28, 2006

Dear DLB:

Please see the help for the DateDiff function.

Tom Ellison

Guest · Mar 28, 2006

DateDiff("m",#3/1/2006#,#11/1/2007#)

or

DateDiff("m",[Date 1],[Date 2]#)