Hi all,
 I have a report where I am pulling  field titled inspection date. There can be numerous inspection dates for each record, and I only want to see the most recent one. What is the trick or formula for pulling on the most recent by date?

Thanks,
Flanman


Edited by flanman - 02 Dec 2009 at 10:25am

Not sure if I understand. Sorry I am a bit of a newbie with CR.
I have a group or records that may be something like this.

Record ID                                 date
5                                             5/15/2009
5                                             6/16/2008
5                                             7/15/2004
6                                            10/15/2009
6                                             8/25/2006

I only want to see the most recent date for each record so my result would be:
Record ID                                 date
5                                             5/15/2009
6                                            10/15/2009

That worked like a charm. Thanks a bunch.

Now can I create a formula or filter on just that most recent date?

MY goal is to create a date range filter on that date which is only the most recent date for each record.

Unfortunately I only have read access from the data source (SCL) So my filtering/selecting has to be done in CR. 

What I have is a database with  location information in it. These locations have inspection dates that have to be renewed each year before the location can be used again. Since we have used these locations for several years they have several inspection dates and I am only interested in the most recent inspection dates. My final goal it to make look ahead 6 weeks on an event schedule and see if any locations inspection dates will be come outdated before the event. Hopefully that makes sense. 
Example - We have an event on Feb 2, 2010 and most recent inspection date was may 5, 2009. That is fie.
Example 2 - We have and event on March 17, 2010 and the last inspection date was Jan 2009. That inspection will be outdated by Jan 2010 and will need to be updated before the Event date. My goal is to create a report where locations fall into the example 2 category. I have my formula for doing the date lookup an comparison done. My stumbling point is when I run the report I am getting older inspections from say 2007 and 2006, which is throwing off the report since the locations will also have more recent inspections and and the most recent inspection date is the only one I  need. Maybe my formula might help explain.
(EventDate)>=((InspectionDate)+365)
The report also has a select criteria to look out six weeks (CurrentDate+42) so we can see upcoming events that fall into this category.

Sorry for all the details, but I have been stuck on this for two days.

Any and All help is greatly appreciated.