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.

 

Date

01/1/18

01/3/18

01/10/18

 

Greatest     = 01/10/18

Least          = 01/1/18

Outcomes