CiviCRM Community Forums (archive)

I have an interesting question I've not gotten before.  Someone has asked me to provide a way to answer this goal.

"We want to know everyone who has existed in our CiviCRM database for more than 2 years who has never made a Contribution."

NOTE: This is very different than asking "Who has never made a contribution?"

I looked at the schema in the db, and there is no, for lack of a better term, "Contact created on" date in the civicrm_contact table.  Is there such a date, to answer the question, "When was a contact created?"

Ideas? Am I missing something simple here?

Got that. 

But I'm not seeing any way the change_log data is exposed to a search form like Advanced Search or Search Builder.  My guess is I'd have to write a custom query and custom search to gather the oldest change_log date for a particular contact, would I?

Or am I missing a search feature or report that already exists?

excellent.  this helps thanks.  by using this search and combining the results with another smart group that excludes donors, I should achieve my goals