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?