AnsweredAssumed Answered

perform and keep sorted

Question asked by NicolasFasel on Feb 5, 2014
Latest reply on Feb 5, 2014 by 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...

Outcomes