title: Search within yearly quarter
body: <p>Hello I'm trying to figure out how many different EFTs my company runs each quarter then year to date. Is it possible to do something like this?</p>
  
  <pre><code>SELECT DISTINCT Client_no FROM Flat_xTransactions
  WHERE SCode = 'EFT Active'
  AND Last_Mdt &lt; "April 1st of whatever year the report is ran"
  </code></pre>
  
  <p>Thanks!</p>