Skip to Content
1
Former Member
Nov 03, 2010 at 12:20 AM

MonthsBetween calculation

2268 Views

I am attempting to do a calculation based upon the number of months between two dates.

Ex:

Start..................End...................Months

06/01/2010.......07/31/2010.......2

08/01/2009.......04/01/2010.......9

11/16/2009.......04/01/2010.......6

I'm attempting to do this using:

(MonthsBetween([Start]; [End]) + 1)

within WebI. However, it WebI is not counting a month if there is not a full 30/31 days between the start and the end:

Ex:

Start..................End...................Months

11/16/2009.......04/01/2010.......5

Even though the documentation shows that it should:

MonthsBetween([Sale Date], [Invoice Date]) returns 1 if [Sale Date] is 30 December 2001 and [Invoice Date] is 2 January 2002

Anyone have any suggestions to make this work correctly?