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 is the profile and package?
Can any body Explain me what are the critical problems you have faced in the designer and repoting level in the real time environment?
Explain when to use local filter and when to use global filter?
What is DSS?? (Defination of DSS)
I HAVE DRAGGED OBJECTS IN QUERY PANEL.... IF I CHECK THE SQL QUERY IT WAS SHOWING 2 QUERIES IN WHAT SITUATION IT WILL HAPPEN?
'Add objects to the folder' (id - 1) for 'Auto Loans' (id - 2626). Please contact your system or permissions administrator if you require this right.
Can anybody tell me the difference b/w canned and adhoc reporting?.
Hi, difference between loop and trap in business objects ? Thanks in Advance nvsraghu
What is the degenerated Objects?
how to create reports on screech?
What is the Computation error? how to solv it?
If there is no common dimension? Is it possible to combine two different dataproviders?