Skip to Content
0
Former Member
Jan 30, 2014 at 05:31 AM

Date conversion in Universe

2633 Views

Hello all,

Am facing problem with converting date from one format to another for the custom Object in the Universe.(BO XI 3.1 version)

Presently date format is in mm/dd/yyyy HH:MI:SS AM ,

And i want to convert the date format into dd-Mmm-yyyy format ,which is not happening now even after using the below query in custom object.

The parsing is 'OK' and also When clicked on Object properties --> properties -->Display --> It is showing data again in mm/dd/yyyy HH:MI:SS AM format.

to_date(to_char(BO_VIEW.FIELD1,'dd-Mon-yyyy'),'dd-Mon-yyyy')

I need to use this custom object as a prompt in Webi , Hence when report is run in Webi it should accept the date in the format dd-Mmm-yyyy only.

Kindly help on this.

Thanks in advance

Arjun