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

How do scheduling the report in BO XIR2? can you say what are they steps?

5 Answers  


I am trying to save the XI report to CSV format. the csv file not displaying columns in order. all the columns are misplaced. the report size is 12MB Can any one tell me why the columns are incorrect position when XI report converted into CSV format?

3 Answers  


How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes

0 Answers   Infosys,


Can we start CMS server from CMC? Is yes can anyone tell me how plz Thanks in advance?

2 Answers   Barclays,


If the Hi-rarchies are not defined in the universe level .Is it possible to do in the report level?

3 Answers   Infotech,






What is shortcut join?could give any one example?

8 Answers  


what is meant by slowly changing dimensions?

3 Answers   TCS,


in xir2 how to send reports to end user

2 Answers   TCS,


3.what is alias?

5 Answers   Business Intelligence Analytics, TCS,


What is BOMain.Key?

5 Answers   Cognizant,


Can we edit BOMain.Key file to connect with other repository with same supervisor user name and password. But Database is different.

2 Answers   TCS, Wipro,


Explain difference between zabo and webi?

0 Answers  


Categories