Answers.Body: <p>One way is to do an exclude search.</p>
  
  <p>Create a smart group that has all the people who have borrowed a tool in the last 6 month.  Create another smart group that contains everyone.</p>
  
  <p>Under Search => Custom Searches you should find the custom search "Include / Exclude Contacts in a Group / Tag".</p>
  
  <p>Include your group that contains everyone.<br>
  Exclude your group that contains the people who have borrowed.<br>
  This should result in the people who haven't borrowed.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-04-21T16:29:47.803Z
Answers.LastActivityDate: 2017-04-21T16:29:47.803Z
Answers.UserDisplayName: Paul-Tahoe
Body: <p>I'm not really sure how to describe this but  hopefully I can describe it clear enough.</p>
  
  <p>I created a custom field set that holds borrowing information for items (like tools, equipment, etc.). It has 3 fields (actually more, but here 3 is enough to describe the problem): Item name, Date borrowed, Date returned.</p>
  
  <p>A contact can borrow multiple items at once.</p>
  
  <p>Is there a way to search for contacts who have not borrowed <em>any</em> item in the last 6 months?</p>
  
  <p>Thank you.</p>
  
Tags: <custom-fields><search><multi-record>
Title: Search custom fields with multiple records
ThreadText: # Search custom fields with multiple records
  
  (Asked by: username_0 on 2017-04-21)
  
  I'm not really sure how to describe this but hopefully I can describe it clear enough.
  
  I created a custom field set that holds borrowing information for items (like tools, equipment, etc.). It has 3 fields (actually more, but here 3 is enough to describe the problem): Item name, Date borrowed, Date returned.
  
  A contact can borrow multiple items at once.
  
  Is there a way to search for contacts who have not borrowed *any* item in the last 6 months?
  
  Thank you.
  
  **Tags:** custom-fields, search, multi-record
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2017-04-21. Score: 3
  
  One way is to do an exclude search.
  
  Create a smart group that has all the people who have borrowed a tool in the last 6 month. Create another smart group that contains everyone.
  
  Under Search => Custom Searches you should find the custom search "Include / Exclude Contacts in a Group / Tag".
  
  Include your group that contains everyone.  
  Exclude your group that contains the people who have borrowed.  
  This should result in the people who haven't borrowed.
  
  
  ---
  
  