AnsweredAssumed Answered

Date fields - how to find most recent date, 2nd most recent, 3rd most recent, etc?

Question asked by VenturaDon on Nov 26, 2011
Latest reply on Nov 27, 2011 by VenturaDon

Title

Date fields - how to find most recent date, 2nd most recent, 3rd most recent, etc?

Post

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.
Thanks!

Outcomes