There will be many instances when one wants to find the duplicate documents & keep the latest (the most current) of them & delete the rest from the DB. This can be achevied by the following simple agent.
The most current is defined by a field called "AppDate".The unique identifier here is "DocNumber".
Create documents having same "DocNumber"& different "AppDate"s using a form & run this agent. The rest is done.
@If(Current = Big;"";@DeleteDocument);
--View Duplicate has two columns,the first column is sorted on "DocNumber",the second is sorted on "AppDate"(Ascending order).
Note: This only works when "AppDate" is greater than the given date(01/01/2000).
This was first published in November 2000