title: SQL Function with dynamic date parameter
body: <p>I have a function that I want to use a date dynamic parameter, but I am getting an error "The multi-part identified "func_RunCode" cound not be bound".</p>
  
  <pre><code>SELECT func_RunCode '1/1/2016', '''' + CONVERT(VARCHAR,GETDATE()-1,101) + '''','N'
  </code></pre>
  
  <p>I want to replace the second date parameter with a dynamic date instead of hard coding the second date. Any suggestions?</p>