Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Perhaps something along the lines of:
date(max({< EmployeeStatus -= {"Permanent Inactive"} , PayStatus = {"Processed"} >} VisitStartDate))
Will help here?
Perhaps something along the lines of:
date(max({< EmployeeStatus -= {"Permanent Inactive"} , PayStatus = {"Processed"} >} VisitStartDate))
Will help here?