MAX

Description

The MAX function finds the maximum number or date in a subform's field or in two or more fields.

Usage

MAX(VALUE1, VALUE2, VALUE3, ...)
MAX(SUBFORM_FIELD.FIELD_NAME)

Remarks

When used with subform fields, the argument to MAX() must include a reference to the form's subform field and then the field within the subform, using the dot notation.

The MAX function accepts arguments with the following types:

  • Number
  • Text
  • Instant
  • Date
  • Week
  • Month

When comparing text, the comparison is case sensitive. That means that "ABC" does not equal "abc".

Examples

Find the date of the last project update

The Indicators Tracking with Global M&E database template has a Projects form with a Monthly reports sub form.

You could add a calculated field to the Projects form to find the latest monthly report for each project using the following formula:

MAX([Monthly reports].Month)

This gives you an overview of the reporting progress per project:

Screenshot of resulting table
Screenshot of resulting table
Next item
TODAY