Function Index

Max

Find the maximum value for a column or group.

Usage

Max(<field>)

field (required) The column to be searched. The function will search Numbers, Dates, and Strings, returning the maximum 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

Max([Invoice Date])
  • Finds the greatest Invoice Date, which is the most recent invoice date.
Max([Name])
  • Finds the name that is the last alphabetically.