Convert Character to Date in BO Universe

[Former Member]

Hi,

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. 14.2.4.2410

[former_member193452]

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?

Jacqueline