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.
