Skip to main content
Solved

Extracting Earliest Date in a Rollup Field


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.

View original
This topic has been closed for replies.

4 replies

Dan_Montoya
Forum|alt.badge.img+17

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

 

 


Forum|alt.badge.img+12

. 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

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

Great, thanks!