Date fields - how to find most recent date, 2nd most recent, 3rd most recent, etc?
I've struggled designing a script to accomplish:
Create 5 individual date fields that will have:
DateField1 = most recent date from Table::RecordedDate
DateField2 = 2nd most recent date from same
DateField3 = 3rd most recent date from same (etc for DateFields 4 & 5)
(There will be gaps between dates in Table::RecordedDate).
I intend to create a link from the new DateField1 (etc) to the matching records shown for the date in the field.
I'm an advanced beginner (FM 11) and spent hours searching the forum, but it's possible I've simply missed an already discussed solution.