Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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 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


Please Help Members By Posting Answers For Below Questions

Explain how we drill up week to month?

1041


How can you first report in Business Objects by using broadcast agent?

3001


How were the reports scheduled and how to resolve unexecuted documents?

2617


Difference between zabo and webi?

1052


What is top business?

986


Explain what sort of existing documents should business analysts refer to when starting on a new project?

949


Explain about a tricky situation for which you found a very simple solution?

939


Explain what are the steps to be taken to schedule the report?

1044


How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?

1089


Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?

942


Can Bo generates the Report from the cubical data Explain?

1987


How to sort the dynamic objects alphabetically on the Universe based on and SQL Server

2233


Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye

1789


Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com

2363


What are the steps to be taken to schedule the report?

902