Function Index

Min

Find the minimum value for a column or group.

Usage

Min(<field>)

field (required) The column to be searched. The function will search Numbers, Dates, and Strings, returning the minimum value.

NOTE: Sort order is affected by your database settings. For strings, 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.

Examples

Min([Balance])
  • Finds the smallest balance. Could be negative.
Min([Name])
  • Finds the first name alphabetically. If Name was “Betty”, “Charles” and “Anne”, the result would be”Anne”
Min([Invoice Date])
  • Finds the lowest Invoice Date, which is the invoice date furthest in the past.