Number of Month

[#1]

If a item has a created on date of say 2/15/2007 and today is 9/4/2009 I need to know the number of month the item has been active.

So, 2007 = 11 (include Feb 2007 as a full month), 2008 = 12 and 2009 = 8 (Only what full months) so I want the number 31.

How do I do this?

Thanks,
Stephen

[prieper]

Hi,

would give it a try with

(Year(2) - Year(1) ) * 12 - Month(1) + Month(2)

HTH

Peter

[#3]

Thanks Peter. It works.