Nhibernate Criteria for the Having and Max query?

See more:

ASP.NET

NHibernate

I am trying to create Nhibernate criteria for the follwing query but not getting the right idea.

SELECT PEH.ResponseStatus FROM PatientEligibilityHistory PEH WHERE PEH.PatientId = " + patientId + " AND PEH.PayorId = " + payorId  + " AND PEH.DateOfService = '" + dateOfService + "' AND PEH.Insured_Id = '" + insuredId + "' HAVING PEH.ResponseDateTime = MAX(PEH.ResponseDateTime) 

I am trying the following Nhibernate Criteria but it is not working .

ICriteria criteria = session.CreateCriteria(typeof(PatientEligibilityHistory));
           criteria.Add(Expression.And(Expression.In("PatientId", patientList), Expression.In("PatientCaseId", patientCaseList)));
           criteria.Add(Expression.And(Expression.In("PayorId", payorList), Expression.In("InsuredId", insuredList)));
           ProjectionList projectionList = Projections.ProjectionList();
           projectionList.Add(Projections.Max("ResponseDatetime"));
           projectionList.Add(Projections.GroupProperty("ResponseDatetime"));
           criteria.SetProjection(projectionList);
           return criteria;

Please guide.