Case Statement with Date

[thomask23]

Hello,

I need to write a case statement that would return a specific variable based on the date.  I tried the below syntax and is recieving an error.  Please advise on the appropiate syntax.

CASE WHEN a.DT > 02Jan2015'd'

     THEN b.STAT

          Else a.STAT end as "STAT"

[art297]

untested:

CASE WHEN a.DT > '02Jan2015'd

     THEN b.STAT

          Else a.STAT end as STAT