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 report template in b.o?
Difference between b.o 5.1 and 6.1b?
What is the difference b/w breaks and sections
What is Complex Reports?
HOW DO YOU RESOLVE MULTIVALUE AND COMPUTATIONERROS?
what is the difference b/w the refresh and buffered data?
'Add objects to the folder' (id - 1) for 'Auto Loans' (id - 2626). Please contact your system or permissions administrator if you require this right.
How to Analyise 'Join' problem and which method is the best to resolve that ?
Can any one say me wat does"maintanence of universe" means wit?
2 Answers Business Intelligence Analytics, NAL, TCS,
Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?
WHAT IS THE DIFF BETWEEN BO6.5 AND BOXI
Without using OBJECTS Can i write AND run a query in webi/desi? HOW?