If you want to see the most recent order date or the last time a tenant paid for rent, you can calculate the most recent or latest date from a connected object using a Maximum formula.
Objects & Date
Before we go through the steps, you'll need to have at least two connected objects and a date field in the child object. For example, you may have Customers connected to Orders and the date field is in the Orders object.
For more information on how formula fields work, take a look at this article: Formulas.
Calculate Most Recent Date
1. In the child object (in this example the Orders object), add a new Equation field.
2. Update the Equation settings as follows:
- Equation Type: Date
- Date Type: hours
- Result Type: Date
The Equation should only include the date field.
This converts the date into a numeric value that can be used by a Maximum formula. Formulas can only work with numbers, not dates.
3. In the parent object (in this example the Customers object), add a new Maximum formula field.
4. Set the "Field to max" to the equation field you created in the child object.