I have a script that does the following:

- show all records

- sort by date (so most current date is last)

- go to last record and date field

Now, based on the contents of that date field, I want to do a second FIND to return all records with that date.

(The reason... sometimes we do our billing and need to unmark the most current billing print date for various reasons. I would be adding the script to a button so anyone can do it without having to call me).

Create a Cartesian self-relationship (using the X operator, so that all records are related to one another) from serial to serial and define it to sort by date descending. Now, relationship::date refers to the most recent date. You can either set this in a global date field and perform a find based on it or create a relationship from a global date field to the date field, set the global with relationship::date, and Go to Related Record [show only related; "relationship"] to isolate all records with that date.