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
How to schedule the report in b.o?
Explain when we use aggregate awareness function in designer?
If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?
Can we create universe with no cache??
What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
Did you face any problems while creating reports? Name? Solutions?
what will be the contents for a functional requirements specifications
how many reports have u created ? explain a few.
Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...
Explain what task is 98% of the required work of a business analyst?
what is the difference b/w the refresh and buffered data?
Explain is there any default username & pwd for bo designer & supervisor?
What are the join problems comes appart from loop,chasm & fan Traps
Explain what is the difference between business requirement document and use case document.
Can Bo generates the Report from the cubical data Explain?