MAX function finds the maximum number or date in a subform's field or in two or more fields.
MAX(VALUE1, VALUE2, VALUE3, ...) MAX(SUBFORM_FIELD.FIELD_NAME)
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.
MAX function accepts arguments with the following types:
When comparing text, the comparison is case sensitive. That means that
"ABC" does not equal
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:
This gives you an overview of the reporting progress per project: