Can the Date be Formatted in BPC? - Version: BPC Release 7.5.112.07/MS

[Former Member]

Hi BPC Community,

We want to format a dimension property in BPC 7.5 to display the date as: Day-Month-Year, e.g., 8-Aug-14. In our existing database we have different formats such as: 01-Oct-2002 or 12/31/2014.

Is there a way to set this property to display dates as: 01-Oct-2002 no matter what the actual input is?

Thanks. Barry

[Former Member · Accepted solution]

Hi Barry,

where are memorized the dates ? Have you built custom tables? It isn't possible to even the dates in a same format?

In this case you have to write some code in VBA to change the date format as you want

Regards

     Roberto