SAP Knowledge Base Article - Preview

1184459 - Date appears incorrectly using formula "=UserResponse("Enter Begin Date:")"

Symptom

In BusinessObjects version 6.5, a WebIntelligence document contains a prompt for a date object. When the user enters the date in to the document, only the month, year and date are to be displayed. Perform the following steps to recreate the issue using the Islands Resort demo universe:

  1. Create a document using Resort and Revenue.
  2. Add a Query Filter with a prompt on Invoice Date: Invoice Date greater than ("Date?").
  3. Run the query. Type "1/14/2004" for the prompt.
  4. Go to Edit Report mode. Create the variable [UserRes] =UserResponse("Date?").
  5. Insert the variable into a Free Standing Blank Cell.

When the report runs, the date is displayed similar to "1/14/2004 12:00:00 AM".


Read more...

Product

SAP BusinessObjects Business Intelligence platform 6.5 ; SAP BusinessObjects Business Intelligence platform 6.5.3

Keywords

UserResponse Web Intelligence prompt date format display , 18817 , 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.