title: How to get a result as CurrentDate - 14 Days
body: <p>I am using this query to get the result of a DateTime Dropdown.
  Query is:</p>
  
  <pre><code>SELECT CONVERT(VARCHAR(50), PeriodStartDate, 106) AS PeriodStartDate
  FROM PayPeriod 
  </code></pre>
  
  <p>I want to populate it according to 14 days before current Date. 
  Somewhat like this:</p>
  
  <pre><code>SELECT CONVERT(VARCHAR(50), PeriodStartDate, 106) AS PeriodStartDate
  FROM PayPeriod
  WHERE PeriodStartDate BETWEEN GETDATE() AND PeriodEndDate
  </code></pre>
  
  <p>Instead of <strong>GetDate()</strong>  how to write it as <strong>GetDate() - 14Days</strong> ?</p>