title: Crystal Reports Date functions
body: <p>I'm trying to select only the records in which their date falls from the current date to the end of the month three months from now.</p>
  
  <p>Currently there are two dates in the table matching the query:  </p>
  
  <pre><code>Judy: 5/17/09  
  asdf: 8/9/09
  </code></pre>
  
  <p>This is my formula:</p>
  
  <pre><code>DateVar current = Date(CurrentDateTime); //takes the time off
  DateVar ThreeMonthsAway = Date(year(CurrentDateTime), month(CurrentDateTime)+4, 1) - 1; // month+4, then -1 days to get last day three months away
  {tblTenant.LeaseEnds} &gt; current AND {tblTenant.LeaseEnds} &lt; ThreeMonthsAway
  </code></pre>
  
  <p>The problem is, it returns no results. If I take off the second part of it, I get both results but I only want the dates within three months.</p>
  
  <p>What am I doing wrong?</p>