02-04-2011 12:04 PM
I'm having difficulty getting the parameters correct for a query that returns a list of contacts that have not had a history recorded in the last xx days. Perhaps this is better accomplished via reports but am looking for someone to jog my memory as I'm pretty sure we've done this in the past.
02-04-2011 02:28 PM
Here's how to build a (LAN/Windows) group to do this:
03-02-2011 02:12 PM
I am having a similar issue and tried the following statement in LAN query builder as you had suggested and got no results.
Is there anything I am doing wrong?
03-02-2011 03:18 PM
03-03-2011 07:43 AM
Yes, tried that still no luck. This is the exact statement I pasted and then checked the box "value is literal".
Select distinct Contactid from History where DateDiff(day, History.Createdate,GetDate()) < 120
Thanks for your help.