Thanks a lot!! this one is working fine!! Now I have another question :w00t:
I already have a view (ED) with the following syntax:
SELECT ContactId,Effective_Date,Semester,'EffectiveGraduationDate'= DATEADD(year, 4, EGD) from ED
Instead of 'EffectiveGraduationDate'= DATEADD(year, 4, EGD)
I need to place the if syntax you gave me...
How it would be?
Sorry I am trying hard here 🙁