Skip to Content

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

Formatting a Date dimension

Can you change the format of a date dimension.  I have a date coming in from my data source in the mm/dd/yyyy format and  I need it to be mm/yy.  I tried FormatDate function but was not successful.  Any suggestions?


Former Member

If it is a date I think we are all making this more complicated than it needs to be.  I think you just need to create a custom format of MM'/'yy.  To do that do the following...

  1. Click on the date column in your report that you want to format.
  2. Click on the "Format" tab in the top row.
  3. Click on the "Numbers" tab in the second row.
  4. Click "Date/Time" and choose a sample format that is close to what you want to seed the custom format you are about to create.
  5. Click "Custom".
  6. Type MM'/'yy in the the Date/Time field.
  7. Click "Add".
  8. Click "OK".

You have to be using the Java Applet or Rich Desktop versions of Web Intelligence to be able to create a custom format.  Once you have done so it can be used in the HTML version of Web Intelligence; it just can't be created there.

Does that help?


1 View this answer in context
Not what you were looking for? View more on this topic or Ask a question