4 Replies Latest reply on Feb 5, 2014 7:12 AM by NicolasFasel

    perform and keep sorted

    NicolasFasel

      Summary

      perform and keep sorted

      Product

      FileMaker Pro

      Version

      12 advanced

      Operating system version

      10.9.1

      Description of the issue

      I would like to obtain the maximum of a calculated field, from a related layout.

      I need to calculate the time elapsed between two date:
      Date - GetNthRecord( Date ; Get ( RecordNumber ) - 1)

      But when this calculation is obtain from the original layout, the dates remain unsorted. It results some negative value...

      If I perform find on the layout with the calculation, the sorting is also not kept...