Actually I think after some advice from our DBA here and playing around, I did this and it works

Select * from (

SELECT ClientName

,Telephone

,apptdate

,ROW_NUMBER() over (partition by ClientName order by apptDate desc) rn

from DailyCalls

where Telephone <>'Invalid Number'

) x

where x.rn = 1