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
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 |
Can anybady tell me , what is the aggrigate awareness.how to use it . could u plz give me the practical example.
how to do Ad-hoc reporting ?
What is a universe?
IF VIEW IS FASTER THAN DERIVED TABLE WHY WE ARE USING DERIVED TABLE IN BUSINESS OBJECTS?
What is pragma?
Explain how to execute the plsql procedure from the report by clicking with mouse?
What is scope of analysis ?
HOw do u migrate from old version to the new version?
WHAT IS THE DIFF BETWEEN BO6.5 AND BOXI
Explain about derived tables?
What is the differrence between prompt & @prompt? What is the differrence between Xcelsius & Web-I Report?
How to hide objects or columns?