Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Rollup Fields with Dates & Min/Max?

Topic Labels: Formulas
Solved
Jump to Solution
905 1
cancel
Showing results for 
Search instead for 
Did you mean: 

I’ve got a rollup field tied to connected records with dates, and I’m not 100% sure how it works.

My goal is to have this rollup field only show the most recent date.

So if it is rolling up from two entries, lets say: 1/1/2020, and 10/10/2020, I only want to see 10/10/2020. I’m assuming I use the MAX() attribute for that…but I’m not sure. Can anyone confirm what the appropriate aggregation formula is to display the most recent date of several in a rollup field?

1 Solution

Accepted Solutions

You’re correct, just use MAX(values) to return the most recent date.

See Solution in Thread

1 Reply 1

You’re correct, just use MAX(values) to return the most recent date.