Number of Months ago.

Hi,
I'm trying to create a function that will calculate the number of months between two dates.
For example:
Sept. 12, 2001 minus July 17, 2000 should yield 14.

Any ideas?

Thanks,
Al.

if u use the datediff function

myStr = datediff(interval$,date1,date2[,firstdayofweek [,firstweekofyear]])

Or perhaps the built in DateAdd function is what you want to use ..... ??

VB Code:

MsgBox DateDiff("m", #7/17/2000#, #9/12/2001#)

VB Code:

MsgBox DateDiff("m", #7/17/2000#, #9/12/2001#)

Thanks all.

Al.