AnsweredAssumed Answered

Issue with Simple Case Statement

Question asked by venkat1 on Jun 27, 2013
Latest reply on Jul 9, 2013 by navzjoshi00
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