Link to home
Start Free TrialLog in
Avatar of Brock
BrockFlag for Canada

asked on

How do I put a datediff with case in a sql where clause

Hello Experts,

Hope you are all keeping well.

Here is what I would like in the where clause of a sql select statement:

DATEDIFF(YY,GAC.BIRTHDATE,GETDATE()) - CASE WHEN DATEADD(YY,DATEDIFF(YY,GAC.BIRTHDATE,TERM.TERM_BEGIN_DT),GAC.BIRTHDATE) > TERM.TERM_BEGIN_DT THEN 1 ELSE 0 END

how do I do this ?  

thanks, Brock
ASKER CERTIFIED SOLUTION
Avatar of Pavel Celba
Pavel Celba
Flag of Czechia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Brock

ASKER

Thanks much appreciated. Brock