Page 1 of 1

MinDate with If function

Posted: Tue Sep 03, 2019 5:44 pm
by 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"))}

Re: MinDate with If function

Posted: Wed Sep 04, 2019 8:22 am
by Lech Kulikowski
Hello,

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

Thank you.

Re: MinDate with If function

Posted: Wed Sep 04, 2019 5:42 pm
by jbreeland
That worked, Thank you!

Re: MinDate with If function

Posted: Wed Sep 04, 2019 7:09 pm
by Lech Kulikowski
Hello

We are always glad to help you!

Thank you.