Symptom
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
=ToDate("20050427";"yyyymmdd")
returns an output of "1/27/05". The month is incorrect.
Why does this behavior occur, and how can you resolve it?
Read more...
Environment
- Web Intelligence version 6.x
- BusinessObjects Enterprise XI3.1 Service Pack 3
Product
SAP BusinessObjects Business Intelligence platform 6.1.3
Keywords
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.