max or latest date for a group of items

[James Maeding]

I have a report that lists files and the date last modified.
My report actually only shows the root folder of the filenames, so I get many rows with the same folder.
The report looks like this (without summary info...):

Root Folder Date last modified Days Since Mods
c:\temp\ 09/21/2004 12
c:\temp\ 09/20/2004 167
c:\temp\ 09/28/2004 19
c:\plots\ 09/21/2004 173
c:\plots\ 07/22/2004 11
c:\plots\ 09/23/2004 145
c:\plots\ 08/11/2004 132
....

In the summary for each group, I want to list the date of the item most recently modified.
the Max() function does not work for the dates, but it does work for the Days Since Mods column.

Wat is the appropriate way to find the latest date for a group of items in the group summary area in a report?

Thanks in advance.

 

[Marshall Barton]

I have a report that lists files and the date last modified.
My report actually only shows the root folder of the filenames, so I get many rows with the same folder.
The report looks like this (without summary info...):

Root Folder Date last modified Days Since Mods
c:\temp\ 09/21/2004 12
c:\temp\ 09/20/2004 167
c:\temp\ 09/28/2004 19
c:\plots\ 09/21/2004 173
c:\plots\ 07/22/2004 11
c:\plots\ 09/23/2004 145
c:\plots\ 08/11/2004 132
...

In the summary for each group, I want to list the date of the item most recently modified.
the Max() function does not work for the dates, but it does work for the Days Since Mods column.

Wat is the appropriate way to find the latest date for a group of items in the group summary area in a report?

Max is the right way to do this. If it doesn't appear to
work for you, then I believe your dates are really text
strings. If so, try this:
=CDate(DateLastModified)

OTOH, why not just sort the group by the date (or CDate) so
they're in order with the latest one last (or first).