Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Rollup Fields with Dates & Min/Max?

Topic Labels: Formulas
Solved
Jump to Solution
2653 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Christopher_Can
6 - Interface Innovator
6 - Interface Innovator

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
Kamille_Parks
16 - Uranus
16 - Uranus

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

See Solution in Thread

1 Reply 1
Kamille_Parks
16 - Uranus
16 - Uranus

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