So I'm trying to show the next action linked to a proposal.

I already got the last action completed for the proposal by using the technique in BB712836, which is:

--create an AsOf date parameter
--create a formula returning the action date if it's less than the AsOf parameter
--putting a Maximum summary in to just get the last one.

I thought I could use the same method for the next action, by creating a formula saying, basically

If the ActionDate >= AsOf parameter and ActionCompleted is False, then return the ActionDate.

Then Summarizing that formula using the Miminum summary. But for some reason Minimum doesn't work.

Oddly (or not, whatever), Maximum works -- if I change the summary to Maximum the date shows up, and it disappears when I use Miminum.

But I don't want the furthest out action, I want the next one. Anyone have any experience with this?

Leaving this up here for future reference: the problem is that Crystal was pulling the blank value for actions that didn't fit the formula criteria. So by sticking an "else date(9999,12,31)" in there, it pulled the actual minimum. That should hold us for the next 7987 years.