title: Crystal Report XI simple If then else statement NOT working
body: <p>I have a simple code if the the "Field_name) is less than "Date"
  diesplay 'Y' else 'N', I am not not sure why crystal is ignoring the Condition and only seems to be displaying the else part.  I am getting all 'N's even when there supposed to be 'Y's.  Does anyone else come across with this issue, Please HELP!!!</p>
  
  <p>code:</p>
  
  <pre><code>(case when ((select Distinct y.szrclin_pidm 
               from szrclin y
               where szrclin_start_date &lt; '01-JAN-2011'
               and y.szrclin_pidm = spriden_pidm ) is not null)
             then 'Y'
             else 'N' 
         end ) "Prior Rotations"
  </code></pre>