Skip to Content

Convert Character to Date in BO Universe

Mar 07 at 02:14 PM


avatar image
Former Member


I have a universe which is connected to SAP BW tables.

I retrieve from my ADSO, a date which is a text and not in the correct format I need

I have created an object in the universe to put it in the right format (DD/MM/YYYY HH24:MI:SS), still in character.

For example from this "2/24/2018 13:52:00" in the database, in my object in the universe I obtain "24/02/2018 13:52:00" (and from "12/13/2017" I obtain "13/12/2017 00:00:00")

I now need to convert this object to a date. For that I do :

to_date(my_char_object_convert, 'DD/MM/YYYY HH24:MI:SS')

But when I display the result of that it do not take into account the time.

I have tried to change the display format but it only complete the date with 00:00:00

In my example, the date became 24/02/2018 00:00:00 . I not retrieve anymore the 13:52:00

When I do it in WebI, with a variable (=ALaDate([my_char_object_convert];"dd/MM/yyyy HH:mm:ss") it's working and display correctly 24/02/2018 13:52:00. But I need it to do it in the Universe to create my indicators there (gap between dates, etc.)

I use BI4.2 / V.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Jacqueline Rahn
Mar 07 at 09:26 PM
  1. Did you try to select the Dimension object
  2. Right Click
  3. Select Object Format
  4. Select Date/Time Category
  5. Enter required format. Click OK?


10 |10000 characters needed characters left characters exceeded