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

How to schedule the report in b.o?

1101


Explain when we use aggregate awareness function in designer?

1091


If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?

1071


Can we create universe with no cache??

2573


What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?

1057


Did you face any problems while creating reports? Name? Solutions?

3740


what will be the contents for a functional requirements specifications

2416


how many reports have u created ? explain a few.

2144


Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...

2198


Explain what task is 98% of the required work of a business analyst?

1175


what is the difference b/w the refresh and buffered data?

2408


Explain is there any default username & pwd for bo designer & supervisor?

1061


What are the join problems comes appart from loop,chasm & fan Traps

2188


Explain what is the difference between business requirement document and use case document.

1074


Can Bo generates the Report from the cubical data Explain?

2087