Greetings
Using SQL platform I am trying to calculate the eligibility date for Health Benefits based on an employees Hire Date.
I have tried many derivations of Date Functions and even gone through a few threads here, but it is not working properly
Eligibility Rules
Eligible the first of the month FOLLOWING 90 days of employment, unless the 90th day of employemnt is the first of the month.
So far I have tried :
DATEADD(MM,4,DATEADD(DD,-(DATEPART(DD,PS_EMPLOYEES.HIRE_DT)-1),PS_EMPLOYEES.HIRE_DT))
Any assistance is appreciated
Using SQL platform I am trying to calculate the eligibility date for Health Benefits based on an employees Hire Date.
I have tried many derivations of Date Functions and even gone through a few threads here, but it is not working properly
Eligibility Rules
Eligible the first of the month FOLLOWING 90 days of employment, unless the 90th day of employemnt is the first of the month.
So far I have tried :
DATEADD(MM,4,DATEADD(DD,-(DATEPART(DD,PS_EMPLOYEES.HIRE_DT)-1),PS_EMPLOYEES.HIRE_DT))
Any assistance is appreciated