How to Query "Inaktive" Contacts where ModifiedOn is older then 3 month
Can anyone help me creating a query that select inactive contacts that have a ModifiedOn date older than 3 month?
Only solution I can think on is:
Query = Contact Statecode = 1 (inactiv)
Run through all inactive contacts and then add a IfTheElse step
IF = DATEDIFF("m", contact.modifiedon, GETDATETIME() ) > 3
But the I will run through al lot of inactive contact that is not older than 3 month every time the job runs. Waist of time and ressources!