Find 2nd Most Recent Date SQL with JOINS

I'm trying to return the second most recent date for a set of projects in SQL, but I'm getting the error 'Only one expression can be specified in the select list when the subquery is not introduced with EXISTS.'
Here is my code: