MINIMUM() returns the lesser of set of specified numbers or dates.
Use of variable arrays as a parameter is supported for this function. This means that a list of values can be provided using a single variable array. For more information see Variable Arrays.
MINIMUM() is the opposite of the MAXIMUM() function.
MINIMUM(N1, N2 <,N3 ...>)
The lessor value of N1, N2, etc. is always returned. If a variable array is used as one of the parameters, all values in contained in the variable array are compared to any other listed parameters.
If the number of decimals in a set of numbers is different, MINIMUM() adjusts the result to the greater number of decimals.
Date values are entered as YYYYMMDD regardless of the date format of the DATE field being referenced.
If a variable array is used as one of the parameters, all values in contained in the variable array are compared in conjunction with any other listed parameters.
MIN(4,7) = 4
MIN(7.5,4) = 4.0
MIN(7,4.55) = 4.55
MAX(4,6,7) = 4
MAX(‘20120420‘,‘20120630‘,‘20120814‘) = ‘20120420‘
In an inventory file, to create a field containing the lower of the Cost and Sale price, specify:
MINIMUM(Cost,Salepr)