MinListValue18 ( lst ; Type_1Text_2Numb_3Date_4Time_5TS )

Determines the minimum value from a ¶-delimited value list, depending on data type, and requires FileMaker 18 or later

Be the first to rate this function Log in to vote

Bill Thurmes - Show more from this author
MDCA
http://www.miyotadca.com

Sample input:

MinListValue18 ( "-123¶-5¶-12¶-97.6" ; 1 )
MinListValue18 ( "-123¶-5¶-12¶-97.6" ; 2 )

Sample output:

-12
-123

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

/*-------------------------------------------------------
# MinListValue ( lst ; Type_1Text_2Numb_3Date_4Time_5TS )
# lst is a ¶-delimited list
# Type is the data type, conveniently given a name where you don't have to look up the data type
# 
# Function as suggested by Fabrice Nordmann
--------------------------------------------------------*/
GetValue ( SortValues ( lst ; Type_1Text_2Numb_3Date_4Time_5TS ) ; 1 )

Selects the minimum value from a value list. The type is the second parameter, after the value list. Since it uses the SortValues function, it requires at least FMP 16.

Comments

		Bill Thurmes, MDCA Nov 12, 2019
This function has been changed; please see my comments concerning MaxListValue

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

MinListValue18 ( lst ; Type_1Text_2Numb_3Date_4Time_5TS )

Comments

Support this website.

Support this website.