Date format in LOV

building reports desktopintelligence
1

Hi All

By default BO displays date in ‘mm-dd-yy hh:mm:ss’ format in List of Values
box. Is there any way to display only date (I don’t want time)

Vasan

Baton Rouge International, Inc
Data Warehousing and OLAP Consulting Division
http://www.bri.com

Listserv Archives (BOB member since 2002-06-25)

2

If you are using ORACLE you use the trunc function.
Trunc() will return only the date and not the time. Of course you
have to make the change in the universe.
Good Luck

Listserv Archives (BOB member since 2002-06-25)

3

I’ve used the trunc function on ORACLE. It displays all dates with the time
12:00:00AM in the LOV.

George Baranowski
QuadraMed

If you are using ORACLE you use the trunc function.
Trunc() will return only the date and not the time. Of course you
have to make the change in the universe.
Good Luck

Listserv Archives (BOB member since 2002-06-25)

4

George,
You are correct. It does returns 12:00AM with all the rows. But
in ORACLE the trunc function does get rids of the time stamp. In
Business Objects the actual time is replaced by 12:00AM.
Dilip

Listserv Archives (BOB member since 2002-06-25)

5

Dilip

My dates in database are stored without any time component anyway.

I don’t want to see time component in LOV dialog box of BusinessObjects.
Is there any way.

Vasan

Baton Rouge International, Inc
Data Warehousing and OLAP Consulting Division
http://www.bri.com

George,
You are correct. It does returns 12:00AM with all the rows. But
in ORACLE the trunc function does get rids of the time stamp. In
Business Objects the actual time is replaced by 12:00AM.
Dilip

Listserv Archives (BOB member since 2002-06-25)

6

The only way I can think of is by using the substr function. BO returns
the time along with the date because of the way it is defined in the
.sbo file since it issues a ALter session command to the database
everytime.
to_date(substr(,1,10)) will return just the date not the time.
Good Luck

From:
Balagurusamy.Srinivasan@ERCGROUP.COM[SMTP:Balagurusamy.Srinivasan@ERCG
ROUP.COM]
Sent: Thursday, March 11, 1999 2:06 PM

Importance: High

Dilip

My dates in database are stored without any time component anyway.

I don’t want to see time component in LOV dialog box of
BusinessObjects.
Is there any way.

Vasan

Baton Rouge International, Inc
Data Warehousing and OLAP Consulting Division
http://www.bri.com

George,
You are correct. It does returns 12:00AM with all the rows.
But
in ORACLE the trunc function does get rids of the time stamp. In
Business Objects the actual time is replaced by 12:00AM.
Dilip

Pls report bounces in response to postings to
BUSOB-L-Request@listserv.aol.com
Web archives (24 hrs. a day now!):
listserv.aol.com/archives/busob-l.html
OR search: Mail to listserv@listserv.aol.com, ‘search a_phrase in
BUSOB-L’
Unsubscribe: Mail to listserv@listserv.aol.com, ‘unsubscribe BUSOB-L’
====================================

Listserv Archives (BOB member since 2002-06-25)

7

The substr functions works fine. It will only return the Date and not
the time.
substr(,1,10) will return the date and not the time. It will
remove the time stamp from the query.

Listserv Archives (BOB member since 2002-06-25)

8 
 Vasan,

 Just I have seen your mail in the middle.  What I understood is, you
 are receiving records with dates & time.  If you want to avoid the
 time, just go and change the properties of that object by using DATE
 function like:

 DATE(objectname).  it will show only the dates.

 Hope it helps.

 Ravi.

Listserv Archives (BOB member since 2002-06-25)

9

Ravi,
when i use the date function in designer with the object definition, it
doesnot allow me to use Date,
function in designer and it tell me as Date is not a valid function

Listserv Archives (BOB member since 2002-06-25)

10

Hi There,

In case of Oracle check the settings in
\BusinessObjects\Oracle\Ociv7.sbo

InputDateFormat=‘DD-MM-YYYY’
InitDateFormat=‘DD-MM-YYYY’

Use these settings in combination with trunc.

This should work …

Best regards,

Vides Tamaela

Listserv Archives (BOB member since 2002-06-25)

11

Arvind,

You can try the following

    to_date(substr(<date>,1,10),'mm/dd/yyyy') in designer.

Thanks
Tarak

when i use the date function in designer with the object definition, it
doesnot allow me to use Date,
function in designer and it tell me as Date is not a valid function

|--------------------------------------------------------------|
|Tarak N Ray (408) 428 5431 tarak@cadence.com |
±-------------------------------------------------------------+

Listserv Archives (BOB member since 2002-06-25)

12

Hi,

Can you tell me how to do this in BO 6.5.1. There is only one file called oracle.sbo
I tried adding these lines to it

DD/MM/YYYY
DD/MM/YYYY

But it did not work.

Thanks.
Manish

mmanish :india: (BOB member since 2005-10-31)