Skip to main content
Solved

Rollup Fields with Dates & Min/Max?

  • August 10, 2021
  • 1 reply
  • 149 views

Forum|alt.badge.img+7

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?

Best answer by Kamille_Parks11

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

1 reply

Kamille_Parks11
Forum|alt.badge.img+27

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