Skip to Content
avatar image
Former Member

IDT Date Format Not Reflecting In Design Studio


I am using Design Studio 1.4 and creating an application on top of a UNX which is built on top of a ECC Table.

We have a object at the UNX Level with "Date" type. The default format is "May 1, 2013". We changed it to different formats like "May-2013","1st May, 2014" etc. through the "Edit Data Format Display" option athe Object Level in IDT.

Here are the screenshots.

Default Object Format:

Customised Object Format In IDT:

Updated Format In IDT:

When I use this Object at the Design Studio side, the data source displays the default format as defined on the ECC end. However, when I click on the "Edit Query Specifications", the results preview panel does reflect the updated data format as defined in the UNX.

Here are the screenshots:

Data Preview under "Edit Query Specifications" while defining the Data Source on UNX, it reflects the updated format like "Jan-2014":

Data Preview On "Edit Initial View" of Data Source, displays the original format as on the ECC side:

Application view also refers to the original data format as in ECC:

Has anyone come across this issue?

Thanks & Regards,


Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Dec 18, 2014 at 02:03 PM


    Design Studio is formatting the dates based on the user locale (which is coming mainly from browser local, but can be also changed in the system). This means any special date formats are (normally) ignored.

    In your case I am not quite sure how this is handled as this is the Universe specification. If the definition is an official function (which seems to be) you could open customer incident - as this could be also a bug on the way between the BICS layer and Universes.


    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 03, 2016 at 09:50 AM

    We are facing similar issue, the source is BW. Have you received any resolution?



    Add comment
    10|10000 characters needed characters exceeded