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
Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.
How would you format some text using css to be verdana and bold?
What are the data types present in bo? What happens if we implement view in the designer and report?
Explain about alerts in bos, under what situation we need to use alerts?
Explain in detail about type 1?
Explain is data mart?
How to schedule the report in b.o?
what is document design in boxi,have u participate in that
How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?
What is Indexing? how did u implement indexing?
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
How to open a universe with out using the Designer ??
Which versions are used in the bo dashboard work?
hi all of u, i want to learn the course in SAP(BI).because of there is no calls for BO. And the another region is it will be converted into SAP module. is it OK for me? is there any feauture in coming days? could any one plz send me the message
please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.