Max () with a condition

[Anonymous]

Hi QV Expert

I have a list of dates, and each date has a status of either completed or failed. I would like to create a variable for the max date when the status is completed. What would be the expression?  I was trying set analysis, vMaxDate = Max({<Status = {'Completed'}>}Date), but it didn't work...

Thanks!

[sunny_talwar · Accepted solution]

I don't see anything wrong with the syntax.. what result do you see when you use this variable in a text box?

[Anonymous]

Ha. I had a typo. It's working now. Thanks

[sunny_talwar]

Awesome

I am glad you found the typo quick enough

Best,

Sunny