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!

(4) Answers