title: Date Range From Single Date
body: <p>I need to create a date range based on a date from a monthly file with the results grouped by EmpID and StatusCode. </p>
  
  <p>The "start" date would be the beginnning of the earliest month and "end" would be the last day of the month for the last month in the grouping. Thank you!  </p>
  
  <p>Table:</p>
  
  <pre><code>EmpID   StatusCode  AsOF
  12345   J   6/30/2014
  12345   J   7/31/2014
  12345   J   8/29/2014
  12345   J   9/30/2014
  12345   G   10/31/2014
  12345   G   11/28/2014
  12345   G   12/31/2014
  12345   G   1/30/2015
  12345   G   2/27/2015
  12345   M   3/30/2015
  12345   M   4/30/2015
  12345   M   5/29/2015
  12345   M   6/30/2015
  12345   G   7/31/2015
  12345   G   8/31/2015
  12345   G   9/30/2015
  12345   G   10/30/2015
  12345   G   11/30/2015
  </code></pre>
  
  <p>Expected Result:</p>
  
  <pre><code>EmpID   StatusCode  Start   End
  12345   J   6/1/2014    9/30/2014
  12345   G   10/1/2014   2/28/2015
  12345   M   3/1/2015    6/30/2015
  12345   G   7/1/2015    11/30/2015
  </code></pre>