Returning information of a shift whilst using Max Date

[JamesMF82]

Good morning all!

I was hoping someone would be able to help with an issue I have returning information on shift. I have a table that has a series of shifts associated with Employees, the dates and times they did the shifts and also a pay status on there. What I want to do is return the max date when the pay status is "processed"

I am using the following 

=if(EmployeeStatus <> 'Permanent Inactive', date(max(VisitStartDate)))

But I am not sure where I should add the Pay Status info, as then adding it into the above for example:

=if(EmployeeStatus <> 'Permanent Inactive' and PayStatus = 'Processed', date(max(VisitStartDate)))

It returns no information.

Any help would be great.

Thank you

[Or · Accepted solution]

Perhaps something along the lines of:

date(max({< EmployeeStatus -= {"Permanent Inactive"} , PayStatus = {"Processed"} >} VisitStartDate))

Will help here?

[JamesMF82]

Amazing! Thank you, I realised I needed "Processed Shift" and not "Processed" as well but the set analysis made it a lot easier!