• 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 🙁