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



date format in report like (22/5/2010 "3:20:15 am") like this i want to remove 3:20:15 r..

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

Post New Answer

More Business Objects Interview Questions

What would you consider as your biggest achievement and why?

0 Answers  


what is universe null

0 Answers   TCS,


what do u mean by merged dimensions in Business Objects

2 Answers   Business Intelligence Analytics, TCS,


How to resolve the partial result error in the report

4 Answers   Keane India Ltd,


Explain the diff security levels of Private, Public, Controlled, Confidential, Restricted.

1 Answers   TCS,






Pls say any one... how will u create a report using oracle stored procedure? could u pls send me the step.....

4 Answers   TCS,


10.why we are going to data warehouse?

4 Answers   Satyam, TCS,


How to create Universe using Flat file in BO6.0

1 Answers  


How many ways you can restrict data in business objects?

5 Answers   TCS,


can anybody tell me about issues faced while creating reports

3 Answers   Accenture,


what is canned universe and canned reports in bo?

1 Answers  


What is the profile and package?

0 Answers  


Categories