I have a report where I  am pulling a list of events by company within a 90 day time frame. Some companies have several events in the details section. One of the fields I am pulling is a date field. I need to create a formula that compares each of the dates in the detail field and if the difference is less that 56 days I need to see that date. Something like this.

Company 1
     Event1                         Jan 05, 2010
     Event2                         Feb 18, 2010
     Event3                         March 24, 2010

Company 2
     Event 1                       Jan 01, 2010
     Event 2                       Mar 15, 2020

I already have a preset 90 day range or pulling the initial dates.
The filter I would create would compare Company 1 Event1 date to Event2 date, and Event 2 Date to Event 3 Date and if any are within 56 days show those items.
Based on the filter Co. Company 2 would not show as the dates are more than 56 days apart.
Hopefully that all makes sense.

Flanman

Moving Company to group footer is fine, but not sure what you mean by handling the last row in the group. I want to compare all dates so if there are 2 dates then just those two. If there are multiple dates then date1 to date2, date2 to date3, date3 to date4 etc. The dates are already in chronological order so I don't need to compare date1 to date3 etc. But I am lost on how to even create the formula to do the comparison.

YOu can then use this RT for suppression condition on teh footer. Note it won't suppress your header because the RT does not work in a header.

You have to parenth around the NEXT function...Next(table.field) ... and around the Datediff...Datediff('d',startdate, enddate)...

Edited by DBlank - 02 Mar 2010 at 11:55am

I am trying to calculate a similar formula.  Difference between two date fields.  I used the same formula in this thread.  I get an error  of "A date is required here".  Any ideas on how to fix this?