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"))}
MinDate with If function
-
- Posts: 6243
- Joined: Tue Mar 20, 2018 5:34 am
Re: MinDate with If function
Hello,
Please try to use the MinDateIf() function:
{MinDateIf(DataBand1, DataSource.DateColumn, DataSource.ConditionColumn.Contains("condition"))}
Thank you.
Please try to use the MinDateIf() function:
{MinDateIf(DataBand1, DataSource.DateColumn, DataSource.ConditionColumn.Contains("condition"))}
Thank you.
Re: MinDate with If function
That worked, Thank you!
-
- Posts: 6243
- Joined: Tue Mar 20, 2018 5:34 am
Re: MinDate with If function
Hello
We are always glad to help you!
Thank you.
We are always glad to help you!
Thank you.