Design studio Date format change

[system]

Hi All,

I have designed a Dashboard report using design studio 1.5. We have one date field in that which contains date in “dd.mm.yyyy” format but we want that field to be displayed in “mm/dd/yyyy” format. I am not much into scripting. Is there anyway that I can achieve this through global script or any other functionality?
As we don’t get the fields present in a datasource in Design studio so I am not sure that if we can achieve this in DS or not.
Any suggestion is appreciated.

Thanks & Regards
Arpit Arora

---

arpitarora3000 (BOB member since 2013-10-01)

[system]

[Moderator Note: Moved from General Discussion to Xcelsius - Crystal Dashboard Design]

---

Marek Chladny (BOB member since 2003-11-27)

[system]

Hi,

You can’t define the format of the date field in design studio.

The format for numbers, dates and times varies according to the defined language setting in the BI launch pad or
the Web browser.

(From design Studio Administrator guide (page 72) : https://websmp109.sap-ag.de/~sapidb/012002523100018707472014E/ds14_admin_bip_en.pdf)

• If you define a language in the BI launch pad under Preferences Locales and Time Zone Preferred
  Viewing Locale , this language is used, and numbers, dates and times are displayed in the appropriate
  format.
• If you select Use browser locale under Preferences Locales and Time Zone Preferred Viewing Locale ,
  the Web browser language is used, and numbers, dates and times are displayed in the appropriate format.

---

Fylim (BOB member since 2015-08-20)