Hi, Let's say I have 6 documents and each document has 2 fields (i.e. CustomerName and OrderDate). For example:
Doc 1 John 20120115 Doc 2 Mary 20120113 Doc 3 Peter 20120117 Doc 4 Kate 20120208 Doc 5 John 20120211 Doc 6 Alan 20110423 Is there a way to execute a search to return the document with the most recent OrderDate for a CustomerName? For instance, if I search for John, it should return Doc 5 (because Doc 5 is more recent than Doc 1). Thank you.