title: WHERE date_field OPERATOR Month/Day/(Variable Year)
body: <p>I am trying to pull invoices that are greater than or equal to October 1 (Variable Year) for every year's renewal season. I can hard code this every year, but I'd like to not have to do this because the SQL code is embedded in a child form of a CMS (netFORUM Enterprise) and run through another application and that's too many parts to keep up.</p>
  
  <p>So, the hard code starting in 2016 would look like this:</p>
  
  <pre><code>WHERE my_date_field &gt;= '10/01/2016'
  </code></pre>
  
  <p><strong>NOTE, I would run the query with this code a few times starting October 2016 and throughout the months of 2017 before October 2017.</strong> Keep in mind that some old invoices may still be present on their account from two years back (10/1/2015), which I don't want to appear in my results.</p>
  
  <p>I've pondered through a few types of method, both can't quite get it. </p>
  
  <p>Thanks in advance!</p>