Skip to main content
Solved

Extracting Earliest Date in a Rollup Field

  • March 19, 2024
  • 4 replies
  • 162 views

Forum|alt.badge.img+12

I looked for other solutions on the forum and either I'm too much of a novice to know how to solve it or it didn't work for my problem. I have a rollup field that is collecting multiple dates. I'd like to have it only return the earliest date in the list.  Is that possible?  I tried using MIN(values), but only got a 0 in the field.  Thanks!

Best answer by Dan_Montoya

Mine worked with the date fields being a lookup field (yours is a rollup). Then do a rollup on the lookup.

4 replies

Dan_Montoya
Forum|alt.badge.img+17
  • Employee
  • March 19, 2024

. You can do a rollup of your dates field and take the minimum one.


Forum|alt.badge.img+12
  • Author
  • Inspiring
  • March 19, 2024

. You can do a rollup of your dates field and take the minimum one.


Yes, I tried that, but I get only a 0 as the value in the cell...


Dan_Montoya
Forum|alt.badge.img+17
  • Employee
  • Answer
  • March 19, 2024

Mine worked with the date fields being a lookup field (yours is a rollup). Then do a rollup on the lookup.


Forum|alt.badge.img+12
  • Author
  • Inspiring
  • March 20, 2024

Great, thanks!