Skip to Content
0
Former Member
Jul 30, 2008 at 09:04 PM

How do I get MonthsBetween to work as documented?

241 Views

According to my WebI documentation:

"MonthsBetween([Sale Date]; [Invoice Date]) returns 1 if [Sale Date] is 30 December 2005 and [Invoice Date] is 2 January 2006"

However, in WebI, the formula:

=MonthsBetween(ToDate("123005";"MMddyy");ToDate("010206";"MMddyy"))

returns 0.

This is in XI R2. My questions are as follows.

(1) Will this be fixed in a future release?

(2) What is the recommended workaround until then, for creating reports with month-by-month aging buckets? I see ways to do this, but they all involve either introducing complex modulus arithmetic or extremely verbose conversions of the form Date->Integer->String->Date.

Thanks, Eric

Edited by: Eric Hirst on Jul 30, 2008 11:04 PM, fixed typo in formula