Answer / chiru

hi, there are two ways to change date format in cognos....

1) In Query Studio right click on Date key and select the Data format ... Select Format type = "Date" In Right Side u will get different formats of date.. there u can select the Format type and click ok and then run the report


2) In Report Studio, right click on Date key and select Format type is "Date" and right side, display the properties... in Properties select the Date Ordering.. in drop down u will get date formats, select and click ok.. now run the report

Answer / nasa

Hello it is possible...

IN ORACLE:----

Datatype is int or varchar... so first convert into date by using date function


Eg: to_date('20040105','yyyymmdd');

By using to_char() use can extract which format you want or which particular thing you want.. ex: month, year, date, time...


Eg: select to_char(to_date('20030503','yyyymmdd'),'DD Mon Yyyy') from dual;


here answer: 03 May 2003


IF you want this feature in Cognos use extract().


Regards,
Nasa...

Answer / venkapa naidu

I Dont the answer in congnos but in ORACLE
SELECT TO_CHAR(TO_DATE(Value,'J'),'DD-MON-YYYY') FROM DUAL;
is the query

Answer / sa

use Extract Function

How to write a condition for multy select in conditional formatting... Eg:- i added list,crosstab, barchart, columchart, guagechart, pie chart for value prompt by using static choices.. if i select multiple that all the things has to be display.. this is requirement how is possible to display..

2 Answers   IBM,

---

What is Render Variable? where u can use?

3 Answers  

---

can anybody tell me when do use 'running total'...give an example for the usage of running total

2 Answers   EDS,

---

Hi Buddies... i want to appear for cognos BI-Author certification. can anyone of you send me cognos latest dump. please help me.. cognoslalitha@gmail.com

4 Answers  

---

How do I remove the hyperlink from the drill through report?

2 Answers   Misys,

---

What is Dynamic Grouping? what is diff between grouping n levelspan?

2 Answers   CybAge,

---

How can you improve performance in report studio level? What is the difference between Cognos sql and Native sql? How can you create cubes in framework manager?

7 Answers   Genpact, iFlex, TCS,

---

write a query to display to 10 max record from the employee table?

8 Answers   HCL,

---

what is textsource variable

2 Answers   HCL,

---

-------------How to do Bursting a Report?

1 Answers   Cap Gemini,

---

what is cardinality that you can give to employee and department query subjects in framework manager?

2 Answers   HCL,

---

Define query studio?

0 Answers  

---