How can I create a report that lists accounts that have NOT had a check in the last 30 days?
If an account has had a check in the last 30 days, I can create a report that lists it (check ins with a from value less than 30 days ago). This does not fit the criteria since I am looking for a list of accounts that have NOT had a check in in the last 30 days.
If an account has two check ins, one more than 30 days old and one less than 30 days old, I can create a report that shows the older check in (check ins with a from value greater than 30 days). This does not fit the criteria since the account has had actually had check in in the last 30 days.
I need to create a report that list accounts without a check in from value in the last 30 days. Is this possible? It seems simple so hopefully I am just missing something.
Thanks!