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 would you consider as your biggest achievement and why?
what is universe null
what do u mean by merged dimensions in Business Objects
2 Answers Business Intelligence Analytics, TCS,
How to resolve the partial result error in the report
Explain the diff security levels of Private, Public, Controlled, Confidential, Restricted.
Pls say any one... how will u create a report using oracle stored procedure? could u pls send me the step.....
10.why we are going to data warehouse?
How to create Universe using Flat file in BO6.0
How many ways you can restrict data in business objects?
can anybody tell me about issues faced while creating reports
what is canned universe and canned reports in bo?
What is the profile and package?