Formula to determine next available date

TPALJA

Im trying to determine the next available date based on end date, Job status as active and the event type contains install. This formula returns a date =MAX(COLLECT({End Date}, {Job Status}, "Active"))

Ive tried adding the contains install but it doesnt return a date

=MAX(COLLECT({End Date}, {Job Status}, "Active", {Event Type}, CONTAINS("Install))