Greetings
I am attempting to find the 1st of the month following 90 days of an employees hire date (EE.HIRE_DT)
So far I have come up with:
DATEPART(MM,(DATEADD(MM,4,DATEADD(DD,-(DATEPART(DD,EE.HIRE_DT)-1),EE.HIRE_DT))) )
However... this isnt working in all cases. For example, if the hire date is 7/2/2007 it is returning 11/1/2007 rather than 10/1/2007.
Can anyone please provide me with some guidance?
Than kyou!!!!
I am attempting to find the 1st of the month following 90 days of an employees hire date (EE.HIRE_DT)
So far I have come up with:
DATEPART(MM,(DATEADD(MM,4,DATEADD(DD,-(DATEPART(DD,EE.HIRE_DT)-1),EE.HIRE_DT))) )
However... this isnt working in all cases. For example, if the hire date is 7/2/2007 it is returning 11/1/2007 rather than 10/1/2007.
Can anyone please provide me with some guidance?
Than kyou!!!!