Table of Contents

How do I find the most recent date from a connected table?

Danielle Kellogg Updated by Danielle Kellogg

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 table using a Maximum formula.

Tables & Date

Before we go through the steps, you'll need to have at least two connected tables and a date field in the child table. For example, you may have Customers connected to Orders and the date field is in the Orders table.

For more information on how formula fields work, take a look at this article: Formulas.

Calculate Most Recent Date

1. In the child table (in this example the Orders table), add a new Equation field. 

2. Update the Equation settings as follows:

  • Equation Type: Date
  • Date Type: seconds
  • Result Type: Number

The Equation should only include the date field.

This converts the date into a numeric value that can be used by a Max formula.

Formulas can only work with numbers, not dates.

3. In the parent table (in this example the Customers table), add a new Max formula field to track the most recent date.

4. Set the "Field to max" to the equation field you created in the child table.

 5. In the parent table (in this example the Customers table), add a new equation field. This field will convert the Most Recent Date field back to a date value.

  • Equation Type: Date
  • Date Type: seconds
  • Result Type: Date
  • Equation: [max] where Max is the formula field you used in the previous field's step.

That's it! Now you will have a field that shows the most recent connected date.

How did we do?

How do I add a logo to my app?

How do I create a field that always shows today's date?

Contact