Last Date Formula help?! 1

[Drakhan]

Is it possible to create a formula that displays the last date from a field that contains several dates? I have a sales database that contains several users, contacts, and dates of their appointments. I would like to create a formula in which I can view just the very last date they contacted the company. Below is an example of the database table:

TABLE NAME: APPOINTMENTS
COMPANY USERID TYPE DATE
------------------------------------------
ABC Co. JSMITH APPOINT. 01/01/2004
XYZ Firm JANEDOE APPOINT. 02/15/2004
ABC Co. JSMITH APPOINT. 02/17/2004
ZZZ Ent. JSMITH APPOINT. 03/03/2004
XYZ Firm JANEDOE APPOINT. 03/23/2004
XYZ Firm JANEDOE APPOINT. 04/15/2004

What I would like the report to show is:

Company User Date
------------------------------
ABC Co. JSMITH 02/17/2004
ZZZ Ent. JSMITH 03/03/2004
XYZ Firm JANEDOE 04/15/2004

Below is what it shows, because I do not have a formula. I am only using the 'fields' to display the data. I've tried using the "Select Expert" to no avail.

Company User Date
------------------------------
ABC Co. JSMITH 01/01/2004
XYZ Firm JANEDOE 02/15/2004
ABC Co. JSMITH 02/17/2004
ZZZ Ent. JSMITH 03/03/2004
XYZ Firm JANEDOE 03/23/2004
XYZ Firm JANEDOE 04/15/2004

The report looks like this:
Company User Date
--------------------------------------------------
APPOINT.COMPANY APPOINT.USERID APPOINT.DATE

Any help would be appreciated. Thank you!

 

[GMcNamara]

Create a group on Company (group1) and a group on appt date (group2). Sort the appt date group descending. Put the information you want to display in the Company group. This will show the company name and the last date.

 

[Drakhan]

That worked! Thank you very much!