title: Date filtering in MS Access SQL
body: <p>I have Access reading from a global database, and there is a column where dates are presented in YYYYMMDD format, and I am looking for SQL code that lets me filter it between yesterday and the first day of the current month (it will not be running on the first day of the month, so I'm not worried about it breaking there).</p>
  
  <p>For example, I currently have it working using the code: Between 20170201 And 20170221</p>
  
  <p>I'd like to have it use a code that is Between [FIRST OF MONTH] and [YESTERDAY]</p>