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



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

Can anybady tell me , what is the aggrigate awareness.how to use it . could u plz give me the practical example.

4 Answers   TCS,


how to do Ad-hoc reporting ?

6 Answers   IBM,


What is a universe?

8 Answers   TCS,


IF VIEW IS FASTER THAN DERIVED TABLE WHY WE ARE USING DERIVED TABLE IN BUSINESS OBJECTS?

1 Answers   Accenture,


What is pragma?

1 Answers  






Explain how to execute the plsql procedure from the report by clicking with mouse?

0 Answers  


What is scope of analysis ?

3 Answers   L&T,


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

1 Answers   AOL,


WHAT IS THE DIFF BETWEEN BO6.5 AND BOXI

5 Answers   TCS,


Explain about derived tables?

2 Answers   Cap Gemini,


What is the differrence between prompt & @prompt? What is the differrence between Xcelsius & Web-I Report?

3 Answers   Wipro,


How to hide objects or columns?

6 Answers   Infotech,


Categories