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:
