Skip to Content
avatar image
Former Member

Convert Character to Date in BO Universe


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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Mar 07, 2018 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?


    Add comment
    10|10000 characters needed characters exceeded