Case and DateDiff error

Try something like below:

Select Case when datediff (dd, Getdate(), Getdate()+4) > 3 then 'late' else 'on time' End

---

Please use Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful.