SAP Knowledge Base Article - Preview

1195797 - Date functions 'FormatDate', 'RelativeDate', and 'ToDate' in Java Report Panel return incorrect results.


When using the date functions 'FormatDate', 'RelativeDate', or 'ToDate' in the variable or formula editor, unexpected results are returned, although the syntax appears correct.

For example, the formula 


returns an output of "1/27/05". The month is incorrect. 

Why does this behavior occur, and how can you resolve it? 



  • Web Intelligence version 6.x
  • BusinessObjects Enterprise XI3.1 Service Pack 3


SAP BusinessObjects Business Intelligence platform 6.1.3


20042 , , KBA , BI-RA-WBI , Web Intelligence , How To

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.