The Min function finds the minimum value for a column or group.
- field (required) The column to be searched. Can be of type Number, Date, and String.
The minimum of strings is determined by sort order, which is affected by your database settings. Sort order is most often blank spaces > special characters > numbers > uppercase letters > lowercase letters.
For numbers, preceding and trailing zeroes most often have no effect on sort order.
- Finds the smallest balance. Could be negative.
- Finds the first name alphabetically. If Name was “Betty”, “Charles”, and “Anne”, the result would be ”Anne”.
- Finds the lowest Invoice Date, which is the invoice date furthest in the past.