Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Webi Date Format

Hello - I am on Business Platform 4.0 SP4 Patch2 and using Webi with a OLAP connection to a multiprovider on a BW system and run a BEx query.  I am retrieving a date field (OBILL_DATE) which defaults to dd.mm.yyyy.  I want it in the format mm/dd/yyyy.  When I right click on the column,  I do not get the option "Format Number" like I do on other number columns.  How can I change the format? I have tried both Webi Rich Client and Webi from the BI Launch pad.  When looking in BW (RSA1), using Analysis for Excel, or using CR for Enterprise it is fine.  Any help will be appreciated.

Former Member replied

Hi Kelly,

if I understand your problem correctly this could help...

Insert the regular dimension field [OBILL_DATE] into the table.

Create a new variable, e.g. "varDisplayBillDate" with qualification "Measure" with a formula looking something like:

=FormatDate(ToDate([OBILL_DATE];"dd.MM.yyyy");"MM/dd/yyyy")

Insert the new variable (e.g. varDisplayBillDate) into the table

right-click on the regular dimension field [OBILL_DATE] and hide dimension

Regards, Uli

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question