MinDate with If function

[jbreeland]

Hello. I'm over my head here, but I'm pretty close to figuring out an expression. I want to retrieve the minimum date giving a certain condition. Here's my attempt.

{MinDate(Data,Details.lastfinishedmilestonedate)If(Data,Details.lastfinishedmilestone.Contains ("Submittal"))}

[Lech Kulikowski]

Hello,

Please try to use the MinDateIf() function:
{MinDateIf(DataBand1, DataSource.DateColumn, DataSource.ConditionColumn.Contains("condition"))}

Thank you.

[jbreeland]

That worked, Thank you!

[Lech Kulikowski]

Hello

We are always glad to help you!

Thank you.