title: Confirm my attempt at converting Crystal reports selection criteria to Oracle SQL
body: <p>I have to create selection criteria for an Oracle SQL query based on a snippet from Crystal Reports.</p>
  <p>I have no experience with Crystal reports so I have been trying to figure it out searching the web, but seem to be just wasting my time - Could not find anything helpful for this kind of task on the web.</p>
  <p>This is the selection criteria that was provided:</p>
  <pre><code>{MATL_USED_VW.MAT_ID} = {?Material ID} and 
  {@Use Date} in {?Previous Use} 
        //@UseDate = Date({MATERIAL_ACTIVITIES.MA_END})
  </code></pre>
  <p>The column data types are all date columns except for the numeric MAT_ID column</p>
  <p>I think this would equate to the following:</p>
  <pre><code>where matl_used_vw.mat_id = :Material_id
    and use_date in (:previous_use, :usedate)
  </code></pre>
  <p>This is just a swag based on assumptions.</p>
  <p>Here's my assumptions on the symbols:</p>
  <p>? - probably is a parameter or prompt for input</p>
  <p>@ -  has something to do with formulas</p>
  <p>// - is continuation of previous line</p>
  <p>{} - encloses an object (text, date number  or whatever)</p>
  <p>I'm not sure of anything here, it's all just a guess.</p>
  <p>If anyone could shed some light on this, I would really appreciate it!</p>