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 Posted / 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 View All Answers
Explain how we drill up week to month?
How can you first report in Business Objects by using broadcast agent?
How were the reports scheduled and how to resolve unexecuted documents?
Difference between zabo and webi?
What is top business?
Explain what sort of existing documents should business analysts refer to when starting on a new project?
Explain about a tricky situation for which you found a very simple solution?
Explain what are the steps to be taken to schedule the report?
How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?
Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?
Can Bo generates the Report from the cubical data Explain?
How to sort the dynamic objects alphabetically on the Universe based on and SQL Server
Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye
Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com
What are the steps to be taken to schedule the report?