title: Add month and date to year as SQL parameter
body: <p>I need to be able to add the month and day to the year for the parameter.</p>
  
  <p>Since our fiscal year starts on July 1st each year, I need to make it so that users can type in the fiscal year 'YYYY' as the parameter and it will return results from the fiscal starting the July 1st the year before that year began and end the July 1st of that year.</p>
  
  <p>For example.  For fiscal year 2016, I would need all records that end after July 1, 2015 and start before June 30, 2016.  Currently users have to remember to Specify July 1st and June 30.  How can I make it so they can just type in the year?</p>
  
  <p>Currently works but requires full date as the parameter</p>
  
  <pre><code>Where (E.end_date &gt; @param1 Or E.end_date Is Null Or @param1 Is Null) And
    (E.start_date &lt; @param2 Or e.start_date Is Null Or @param2 Is Null)
  </code></pre>
  
  <p>But this won't work</p>
  
  <pre><code>Where (A.end_date &gt; @param1 Or A.end_date Is Null Or @param1 Is Null) And
      (A.start_date &lt; DateAdd(day, 1, @param2) Or A.start_date Is Null Or
        @param2 Is Null)
        And
        (A.end_date &gt; dateadd(yyyy,-1,'@param3-07-01') And
      A.start_date &lt; '@param3-07-01' Or @param3 Is Null)
  </code></pre>
  
  <p>SQL, at least in the widget they give me to input SQL into for our records software, doesn't like the syntax of <code>'@param3-07-01'</code> putting a parameter in a date string for evaluation for a date, but it will accept <code>'2016-07-01'</code> will allow other situations where I put parameters inside strings in a where clause, such as <code>Like '%@param1%'</code></p>