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 |
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
Explain what is the difference between business requirement document and use case document.
WHAT PROBLEMS ARE NOT KNOWN WHILE PERFORMING INTEGRITY CHECK?
what is the core universe and what is the active universe?
Iam having an report it contain n number of rows i want to desplay each rows in one colur pls explain me its very important
how we send repotrts/documents to end user
How maually can i define ? If thousends of records exists in a table?
What are the traps ? What are the disadvantages of traps?
What problems you have faced while creating an universe? tell me an incident and how you went about solving it?
How to get the data from the two different sourcess
Can we have multiple domains?
Explain how to execute the plsql procedure from the report by clicking with mouse?