The date is irrelevant since in the final result the PVC and SVC dates could be from a record with a different date. This would be a case when more than one record exists for one EDP and the max(date) PVC or SVC is zero.

Did I confuse you enough? (-:
Daniel