Modify L01 Field to get substring

[former_member193552]

Hi All , I have explorer on unv based olap universe. I am getting planned date as 1/2/2014 12:00:00:00.  I would like to just get 1/2/2014. Can You please help me with right code to eidt this field.  Thanks

[former_member4998]

Hi

Try Below.

1. 1. Changed the Data Type to String via Business Layer and Save ..then check format.

1. 2. if above is not working use the TO_CHAR Function and change the format

   like ...To_CHAR(“SYSDATE",'DD/MM/YYYY')

And also You can share custom display formats for business layer objects between all business layers edited within the information design tool. You can create, edit, or delete the display format for multiple business objects at once.

Find the below screenshot and flow the steps.