Converting Access query into SQL

I am converting an access query into SQL and I cannot put this SUM into my code

TARN Wait: IIf(Date()>[TARN 25 Day Target],"25 Days Complete",Date()-[DIS_DT])

,case where (GETDATE() > [TARN 25 Day Wait]