5 Replies Latest reply on Nov 27, 2011 8:40 PM by VenturaDon

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

    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!