title: Formula for date range from fields in two tables (Crystal Reports)
body: <p>I am trying to create a formula which would allow to pull the records from fields in two different tables and print the date in the report.</p>
  
  <p>1.) I have a report with beginning and ending date parameters.</p>
  
  <p>2.) I also have two formulas <code>{@MinDate}</code> and <code>{@MaxDate}</code> which print the minimum and maximum dates:</p>
  
  <pre><code>minimum{?Event date}
  
  maximum{?Event date}
  </code></pre>
  
  <p>I think I’m good at this point. </p>
  
  <p>3.) I am trying to create a formula which would allow to pull the records from fields in two different tables and print the date in the report.</p>
  
  <p>The closest I have come is:</p>
  
  <p><code>({EVENT.DATE}&gt;= {@MinDate} 
  and{EVENT.DATE}&lt;= {@MaxDate})OR
   ({CALENDAR.DATE}&gt;= {@MinDate}
  and{CALENDAR.DATE}&lt;= {@MaxDate})</code></p>
  
  <p>This formula is giving me a Boolean response, and I think I understand why it is giving me a Boolean response, but I don’t know what to do instead. I am looking for the report to show dates within the original parameters.</p>
  
  <p>I’m am a beginner at Crystal Reports; sorry if this is a novice question.</p>