title: Date from Thursday to last Thursday
body: <p>I am cracking my skull as to how to query records where the date field returns data from Thursday to the previous 7 days (Thursday). This is for reporting and I need assistance. </p>
  
  <p>I had a look at the <code>DATEDIFF</code> function but not too sure how to have this date generic to run the SSRS report automatically.</p>