SAP Knowledge Base Article - Preview

1270874 - Function "MonthsBetween" is giving incorrect values for end-of-month dates in Web Intelligence / Desktop Intelligence


  • MonthsBetween function doesn't work properly - wrong result is returned.
  • When formula "MonthsBetween" is applied on two end-of-month dates, example 31/03/2008 and 30/04/2008, the result is 0, instead of 1



  • Desktop Intelligence XI Release 2
  • Desktop Intelligence XI 3.1
  • Web Intelligence XI Release 2
  • Web Intelligence XI 3.
  • SAP BusinessObjects Web Intelligence BI4.0


SAP BusinessObjects Business Intelligence platform R2


DeskI WebI , KBA , BI-RA-WBI , Web Intelligence , Product Enhancement

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.