Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Rollup Fields with Dates & Min/Max?

Topic Labels: Formulas
Solved
Jump to Solution
3137 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.