In expression check condition Max date equal to date

[sangeethag]

Hi,

I have report date and calculated date in variable.

In my expression have to check condition like

if(Max(ReportDate)=Datevariable, Exp1, Exp1)

Is there any solution for this requirement?

[ecolomer]

Can you explain your question more, please?

[sunny_talwar]

I think you will have to provide more information before we can help you. Do you have a sample you can provide?

[sangeethag]

Thank you for replies.

I have found the solution for this.

We can use like below

if(Max(Date([Report_Date],'DD/MM/YYYY'))=Date('$(vQ1End)','DD/MM/YYYY'),Exp1,Exp2)