title: Crystal Reports 2011: Calculate the number of times a value occures and the number of days in between
body: <p>It occurs to me that I might have been able to find the answer to this but so far i've come up short. Also, I am pretty new to Crystal Reports (2011) so please forgive my ignorance if this is something I've missed. Here's the issue:</p>
  
  <p>I have a report where I am pulling the number of times a value happens for a specific target, specifically how many times a specific procedure happens for a person within a specified date range. I have the results grouped by person. </p>
  
  <p>I show the person, the procedure code and the date the procedure happend within that group.</p>
  
  <p>What I NEED to do now, is to figure out how to return some type of visual indicator that there is at least 3 days in between each procedure for each person.. example..</p>
  
  <p>[<strong>GROUP #1 NAME</strong>]....................[<strong>PROC_CODE</strong>]......[<strong>PROC_DATE</strong>]  </p>
  
  <p>[{Last_Name}, {First_Name}].....PROCEDURE..........PROCEDURE DATE</p>
  
  <p>(Please forgive the "....." as I was trying to space out the headers and results)</p>
  
  <p>Having said all that, the "Procedure Date" I would like to show up in RED if the next result within the group (by person) falls within 3 or less days from the last date. I am really hoping this makes sense to someone. Thank you in advance for your help!</p>