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
Can you please send me the migration related issues .
Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
Explain how we drill up week to month?
Explain about a task that really tested your analytical abilities?
What is the difference between business requirement document and use case document.
Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
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?
What we need to discuss with designer before starting the universe designing.
Can we configure two instances of CMS pointing to two different CMS system databases?
Explain the difference between union and group?
Explain what three things do you consider to be the most important factors for a manager?
What is thumbnail?
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
How many universes can be created in a project?
What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?