Number of Months ago.

[Al Smith]

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.

[beasty1711]

if u use the datediff function

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

[MrGTI]

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

[chrisjk]

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

[MartinSmith]

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

[Al Smith]

Thanks all.

Al.