Due Date (Highlight Issues in Blue where Due Dates are less than Todays Date),I

Due Date (Highlight Issues in Blue where Due Dates are less than Todays Date),I have only Due Date column then how to over come the problem.How to find out which Due Date are less than Today Date...Kindly provide the detail steps
to my mail ID-->asimcognos10@gmail.com

Question Posted / asimcognos10

2 Answers
6282 Views
IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Due Date (Highlight Issues in Blue where Due Dates are less than Todays Date),I have only Due Date c..

Answer / naresh

To get lessthan todays date we need to include one filter
condition in In Query explorer of that report.

In Filter condition give condition as
----- Current_date >= Due date

Here Current_date is congos Function for todays date.

Is This Answer Correct ?

6 Yes

0 No

Due Date (Highlight Issues in Blue where Due Dates are less than Todays Date),I have only Due Date c..

Answer / nasa

just simple oracle functions....

Is This Answer Correct ?

0 Yes

3 No

Post New Answer

More Cognos Interview Questions

How many fact tables and dimension tables in your project?

3 Answers IBM,

Hi All, Is there any way to check whether a value is selected in a Multi-select tree prompt? I have a tree prompt and want to get to know whetehr which values user has selected,i want to so that values on the top of the report. I Have used that paramDisplayValue('paramername'),But it will display only last selected value. For Example i have tree prompt with one level Region- >country->states If user select region Asia it will dislay the all the Countries in that region and then if user select India it will display the states related to india only Suppose Hierachy look like this: Asia->India->Andhra Pradesh. I want to show this hierachy on the top of the report How it is possible? Can you please help me?

0 Answers IBM,

These are few Interview questions i faced.I hope to get help here. 1.Can we convert a Crosstab to List? 2.How do you approach and who tells you what exactly the way report has to be developed so that i meets the client requirements? 3.Can we link the List and Chart thats created in the same report? 4.Where do you edit sql in cognos8 ? 5.What is the difference between native sql and oracle sql? 6.What is the difference between MOLAP and ROLAP? 7.What is the use of BI in datwarehousing? 8.What are set functions? 9.How do you test a report? 10.What are the variables you find in toolbox? 11.How many types of filters are there in cognos8? All the answers r welcomed .U can reach me at vinod.davala@gmail.com

4 Answers IBM,

What is the Main Difference between Conditional Block and Render Variable in Cognos. Both are used for Condtional rendering.But what is the Main Diff?

4 Answers Wipro,

can any body clesrly explain about types of query subjects.that is data source query subject,model query subject,stored procedure query subjects?

1 Answers

what are the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet?

0 Answers IBM,

What is zero-foot print?

0 Answers

what is the difference between java script and html in cognos?

1 Answers IBM,

What do you understand by the term 'model durability'?

0 Answers

What is the difference between regular dimension and derminant?