title: grouping records in crystal reports
body: <p>I have a table in my oracle database, with the following schema: student(studentNumber,name, dateOfCreation).</p>
  
  <p>dateOfCreation is the date in which the student record was created.</p>
  
  <p>In crystal reports, I have to group the records into the following groups, using the dateOfCreation field:</p>
  
  <ol>
  <li><p>Older than 4 weeks(Records whose dateOfCreation is more than 4 weeks ago).</p></li>
  <li><p>Between 2 and 4 weeks (Records whose dateOfCreation is more than 2 weeks ago, but less than 4 weeks ago).</p></li>
  <li><p>Between 1 and 2 weeks(Records whose dateOfCreation is more than 1 week ago, but less than 2 weeks ago).</p></li>
  <li><p>Less than 1 week (Records whose dateOfCreation is less than 1 week ago).</p></li>
  </ol>
  
  <p>I have tried grouping in specified order using group expert, but I just can't find these groups. Please help out. How do I achieve this?</p>