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

[karthikeya]

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..

[jcrouch]

Hi karthikeya,

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

[IN DATE] >= ?yourDate?

[OUT DATE] <= ?yourDate?

Jeremy