title: SQL WHERE clause to pick data for last 7 days
body: <p>I want to build a view on the server with a SELECT statement and pick all records that are created at the last 7 days?</p>
  
  <p>Original <code>creation_date</code> field is in <code>varchar</code> like <code>'18/11/08'</code> and I use the <code>CONVERT(datetime, creation_date,11)</code> to convert it into <code>2018-11-08 00:00:00.000</code>, but I don't know how to do in the <code>WHERE</code> clause, so it only selects all records created for last 7 days.</p>