I am trying to automatically change the stage of a lead based off the last time the lead was communicated with. I have tested this WHERE clause in SQL directly and it works, but for some reason it wont fire in CRM. Any ideas?
Lead_Status='In Progress'
AND Lead_Stage NOT IN('3Day','7Day','14Day')
AND Lead_CreatedDate > '2017-10-20'
AND DATEDIFF(day, Lead_CreatedDate, GETDATE()) >=3
AND (DATEDIFF(day, Lead_CreatedDate, lead_LastCommDate) >=3 OR lead_LastCommDate IS NULL)
AND Lead_Deleted IS NULL