How can I query on last donation made over a year ago, and exclude ecommerce transactions?

JohnM

Has anyone successfully used query builder or report writer to create a list of constituents whose last donation transaction was over a year ago, but will not trigger if an ecommerce purchase was made within the year?