Print Page - GET DATA B/W TWO DATES ( DATES ARE FROM DIFFERENT COLUMNS)

Title: GET DATA B/W TWO DATES ( DATES ARE FROM DIFFERENT COLUMNS)
Post by: karthikeya on 24 Mar 2011 07:52:15 AM

HI GUYS..!
i have 3 fields in my report...
EMP NAME IN DATE OUT DATE
X1 21-jan 19-feb
X2 15-jan 16-feb
X3 19-feb 06-apr
X4 21-oct 02-nov
X5 16-nov 02-dec

NOW MY REQUIREMENT IS.. IN THE PROMPT IF USER GIVES A DATE .. THEN THE CORRESPONDING EMP'S (WHO ARE IN THAT TIME PERIOD) SHOULD DIPLAY.

IN THE ABOVE EXAMPLE, SUPPOSE USER GIVES 14-FEB, THEN X1 AND X2 SHOULD BE THE OUTPUT, IF USER GIVES 01-DEC THEN X5 SHOULD BE THE OUTPUT

SORRY FOR MY STUPID REQUIREMENT BUT IT IS VERY URGENT..... THANK YOU GUYS..

Title: Re: GET DATA B/W TWO DATES ( DATES ARE FROM DIFFERENT COLUMNS)
Post by: jcrouch on 25 Mar 2011 09:13:44 AM

Hi karthikeya,

Try using the date parameter in filters for both of the date fields.

[IN DATE] >= ?yourDate?

[OUT DATE] <= ?yourDate?

Jeremy

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: karthikeya on 24 Mar 2011 07:52:15 AM