title: Date range sets
body: <p>I have a question which is divided in two parts</p>
  
  <p><strong>Part 1</strong></p>
  
  <p>How can I get the following set of records with sysdate as current week?</p>
  
  <pre><code>07-Apr-2013 - 13-Apr-2013
  14-Apr-2013 - 20-Apr-2013
  21-Apr-2013 - 27-Apr-2013
  28-Apr-2013 - 04-May-2013
  </code></pre>
  
  <p>If week is past 07-Apr-2012 - 13-Apr-2013, then next four sets. So always it will have 4 weeks.</p>
  
  <p><strong>Part 2</strong></p>
  
  <p>and if current week falls within the range of dates i.e. 07-Apr-2012 - 13-Apr-2013, I would like to get Monday and Friday from the list.</p>
  
  <p>How can I get the desired output? </p>