AnsweredAssumed Answered

Issue with Simple Case Statement

Question asked by venkat1 on Jun 27, 2013
Latest reply on Jun 28, 2013 by another_martink
Hi

I have a case condition but for some reason its not satisfied

For today it has to satisfy the condition but its not for some reason but its going to else condition

case

WHEN resper.prstart <= sysdate and sysdate <= resper.prfinish -2 then xyzzzz

6/22/13 <= 6/27/13 and 6/27/13 <= 6/27/13 ( 6/29/13 -2)
else

......

6/12213 : prstart
6/29/13 :prfinish






Thanks

Outcomes