AnsweredAssumed Answered

Greatest Date in found Set

Question asked by sam.gedert on Mar 12, 2018
Latest reply on Mar 12, 2018 by philmodjunk

Greetings FMP Family,


A question I hope is a simple one. I am trying to find the greatest date in a found set for a particular field. Also the lowest value date. Meaning the date that was the longest ago.


Essentially looking for the first date and the last date in a given found set.  It's a pretty large set so finding for all and sorting is not really an option from a performance stand point.


Example below.







Greatest     = 01/10/18

Least          = 01/1/18