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!
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!