title: Crystal: Display Nth record based off Parameter
body: <p>Real quick -- I want to display the last detail record that occurs BEFORE a specific parameter date that I choose.  I was trying to write something like this:</p>
  
  <p><code>recordnumber = count(({assign.date} &gt; {?Date}) - 1)</code></p>
  
  <p>or</p>
  
  <p><code>recordnumber = onlastrecord - count({assign.date} &gt; {?Date}) - 1</code></p>
  
  <p>When I click 'check' it highlights assign.date and states "A field is required here"</p>
  
  <p>Whenever I google this I see REALLY COMPLICATED answers to something that I feel should be really simple; and I just don't know enough about Crystal to deploy one of those complicated answers.</p>