date format in report like (22/5/2010 "3:20:15 am") like this i want

date format in report like (22/5/2010 "3:20:15 am") like
this i want to remove 3:20:15 remove from report how can we
do this in bo xi r2

Question Posted / vikram.m

1 Answers
5463 Views
Honeywell, I also Faced
E-Mail Answers

date format in report like (22/5/2010 "3:20:15 am") like this i want to remove 3:20:15 r..

Answer / subramanayam

in webi you can usebellow code
formatdate(<date>;"dd/MM/yyyy")
In deski select the column and go to format cell
then select number tab--> select the required format from
the fiormat section
or
use this bellow formula
todate(<date>,"mmddyy")

Is This Answer Correct ?

3 Yes

0 No

Post New Answer

More Business Objects Interview Questions

How to display the top 5 records along with the additional records,plus their sub and grand totals to be display in the same block.

1 Answers Oracle,

CAN ANY BODY TELL WHAT FUTURE CAREER IN BUSINESS OBJECTS?

0 Answers

what is universe

4 Answers TCS,

HOw do u migrate from old version to the new version?

1 Answers AOL,

How to Shedule the reports in Xi R2

3 Answers iFlex,

how to overcome overflow of data in a report

6 Answers

How can I display the query execution time for a particular DP on Web-I report? Or is there any other way to know the 'exact query execution' time at BO end?

1 Answers

without creating the business view is there possible to create & generate the Crystal reports?

3 Answers TCS,

WHAT ARE THE VARIOUS PRODUCTS IN BO?

2 Answers Polaris,

difference between web intelligence,crystal reports and desktop intelligents

4 Answers

What are the traps ? What are the disadvantages of traps?

5 Answers Wipro,

what do u mean by merged dimensions in Business Objects

2 Answers Business Intelligence Analytics, TCS,

For more Business Objects Interview Questions Click Here