djj (11/11/2015)
As an aside what if you change
TCC.Cntac_Dt >= Cast(Convert(Varchar,GetDate()-120,101) As DateTime)
to
TCC.Cntac_Dt >= Cast(DATEADD(DAY,-120, GetDate()) As Date)
Good call. I was just trying to take off the time, and my date calculation are still not as good as I wish they were. I believe that DateAdd is a function I'm going to be studying over the next little while.
[font="Arial"]“Any fool can know. The point is to understand.”
- Albert Einstein
"DOH!"
- Homer Simpson[/font]