title: Dynamic Date As Column Name in SQL Server
body: <p>On my select statement, I want to call to one of my columns as a dynamic date.</p>
  
  <p>For example, something like:</p>
  
  <pre><code>SELECT &lt;column_name&gt; as CONVERT(DATE, GETDATE() - 1)
  FROM &lt;table_name&gt;
  </code></pre>
  
  <p>This obviously doesn't work.</p>
  
  <p>Any ideas?</p>