title: Crystal Reports Else If statement
body: <p>I can't figure out why this if statement won't work.
  I have a DateTime field DATEFROM and a String parameter (it HAS to be String) periodEnd.
  I would like to calculate percentages depending if these two dates have 1, 2, 3 or more years difference. 
  When I use this formula I get either "100%" or "-" and never the other two options. It's like CR calculates the first IF and if it's true then: "100%" but if it's false, it never checks for the rest of the Else Ifs and goes dirreclty to Else</p>
  
  <pre><code>StringVar percentage:="";
  If (cDate({?periodEnd})-{TABLE.DATEFROM})&lt;=1 Then 
      percentage:="100%"
  Else If (cDate({?periodEnd})-{TABLE.DATEFROM})&lt;=2 Then 
      percentage:="66%"
  Else If (cDate({?periodEnd})-{TABLE.DATEFROM})&lt;=3 Then 
      percentage:="33%"
  Else 
      percentage:="-"
  </code></pre>
  
  <p>Any idea?</p>