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 there any way to know how long the report executes and how many records will be returned before hitting the "run" option?

3 Answers  

---

what is fantrap?

2 Answers  

---

WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGNING UNIVERSES?

2 Answers  

---

WHERE DO YOU USE GLOBAL FILTERS ,EXPLAIN WITH EXAMPLE?

2 Answers   PCS,

---

REGULAR CLASSES for Hyperion Financial Management+ODI+HFR+FDQM is Starting From Sunday, 23th Oct, 7:00 AM IST.

0 Answers  

---

---

can anybody tell me about issues faced while creating reports

3 Answers   Accenture,

---

What is recurring sheduling and batch scheduling?

2 Answers   TCS,

---

Explain about derived tables?

2 Answers   Cap Gemini,

---

I have a situation like one manager can have multiple learners under him. each learner will registered for more than one certifications . their statuses for different courses like completed, inprogress, dropped, no certifications. the question is i have check for each user for statuses if he had some completed certifications i have to get latest completed date and omit all other stauses. if he had no complete staus then i have to get latest inprogress record based on date. like this i have to select only one record for user. but i am getting one row for each status. among all completion status one record, for all inprogress one record, for all dropped status one record. how can i show only one record

0 Answers   Flextronics,

---

What would you consider as your biggest achievement and why?

0 Answers  

---

what are cascading prompts explain with steps

4 Answers  

---

how to coneect to a server in a business objects

1 Answers  

---