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
- 1 Answers
- 5162 Views
- Honeywell, I also Faced
- E-Mail Answers
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
What are all difference between business objects 6.5 and xi r2?
How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.
Differences between business objects and web intelligence reports?
what are the day to day activities of BO administrator ?
i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?
What is the difference between slice and dice and cross tab report?
What sort of existing documents should business analysts refer to when starting on a new project?
If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?
Can we Save (save as) WEBI Doc as DESKI?
what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?
Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
What is a fantrap in business objects?
What are the steps to do to use alerts in bo?
Explain what are the measure objects?
What are the data types present in bo? What happens if we implement view in the designer and report?
