Answers.Body: <p>You can use the search builder to search any fields that are empty or null: </p>
  
  <p>civicrm/contact/search/builder?reset=1 (should be in your Search menu item)</p>
  
  <p>We also use a report for tracking a very similar thing. We use the Contact Report (Summary) Template (it might say Constituent instead of Contact)</p>
  
  <p>As long as you've built the field to be searchable, it will be included in your report (this is a check box at the bottom of the field)</p>
  
  <p>You can then select the fields your interested in seeing and filter the report to show those where the field "Expiry Date" = This Month</p>
  
  <p>We trigger this report to be emailed on the first of the month so you can immediately see who requires renewing.</p>
  
  <p>As you're using a relative date, it will always be current for the month you're in.</p>
  
  <p>You can also build a smart group this way, and always have a current list of those who will expire this month which you can use in searches / mailings as you need.</p>
  
  <p>Hope that helps.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-10-13T22:02:55.290Z
Answers.Text: In the search builder i haven't my custom field, why?
Answers.UserDisplayName: Marco Mapelli
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-10-13T22:18:12.897Z
Answers.Text: it is a multiple record custom field
Answers.UserDisplayName: Marco Mapelli
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-10-14T07:42:07.927Z
Answers.Text: Sorry, I didn't spot that you said it was a field that stored multiple values. We actually don't use that function because those fields aren't searchable and exportable in the same way as a standard field. Would you need a history of all the expiration dates over time? Perhaps you could create a custom activity that you could store that in and then use an activity report to find those scheduled for this month?
Answers.UserDisplayName: Heather O.
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-10-14T10:58:17.283Z
Answers.Text: Yes history. Can i create an activity that take a value in multiple custom field and put the last in the custom not multiple field? And how if yes? Thanks.
Answers.UserDisplayName: Marco Mapelli
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-10-15T07:21:03.613Z
Answers.Text: I wouldn't use the multiple field set function at all. You cannot search, report or export on those types of fields as you can with a standard CiviCRM field. I'd build a single field set to record the relevent data in a custom activity called something like "certificates expiration". You could use the activity date or build a new date field depending on your needs. You can then use the activity report to filter for activities of that type which are expiring that month. You could complete the activity to reflect it had been dealt with, and then create a new activity for the next renewal.
Answers.UserDisplayName: Heather O.
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-10-13T11:33:17.230Z
Answers.LastActivityDate: 2015-10-13T11:33:17.230Z
Answers.UserDisplayName: Heather O.
Body: <p>To contact athletes need to register medical certificates. I added a custom field multiple date expired. How do I retrieve all the contacts that do not have a date or that date has expired? How do I get a monthly list of certificates that expire?
  Thank you.</p>
  
  <p>Marco</p>
  
Tags: <wordpress><custom-fields>
Title: Medical Certificates expiration
ThreadText: # Medical Certificates expiration
  
  (Asked by: username_0 on 2015-10-13)
  
  To contact athletes need to register medical certificates. I added a custom field multiple date expired. How do I retrieve all the contacts that do not have a date or that date has expired? How do I get a monthly list of certificates that expire?
  Thank you.
  
  Marco
  
  **Tags:** wordpress, custom-fields
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2015-10-13. Score: 4
  
  You can use the search builder to search any fields that are empty or null:
  
  civicrm/contact/search/builder?reset=1 (should be in your Search menu item)
  
  We also use a report for tracking a very similar thing. We use the Contact Report (Summary) Template (it might say Constituent instead of Contact)
  
  As long as you've built the field to be searchable, it will be included in your report (this is a check box at the bottom of the field)
  
  You can then select the fields your interested in seeing and filter the report to show those where the field "Expiry Date" = This Month
  
  We trigger this report to be emailed on the first of the month so you can immediately see who requires renewing.
  
  As you're using a relative date, it will always be current for the month you're in.
  
  You can also build a smart group this way, and always have a current list of those who will expire this month which you can use in searches / mailings as you need.
  
  Hope that helps.
  
  > **Comments:**
  > **username_0**: In the search builder i haven't my custom field, why?  
  > **username_0**: it is a multiple record custom field  
  > **username_1**: Sorry, I didn't spot that you said it was a field that stored multiple values. We actually don't use that function because those fields aren't searchable and exportable in the same way as a standard field. Would you need a history of all the expiration dates over time? Perhaps you could create a custom activity that you could store that in and then use an activity report to find those scheduled for this month?  
  > **username_0**: Yes history. Can i create an activity that take a value in multiple custom field and put the last in the custom not multiple field? And how if yes? Thanks.  
  > **username_1**: I wouldn't use the multiple field set function at all. You cannot search, report or export on those types of fields as you can with a standard CiviCRM field. I'd build a single field set to record the relevent data in a custom activity called something like "certificates expiration". You could use the activity date or build a new date field depending on your needs. You can then use the activity report to filter for activities of that type which are expiring that month. You could complete the activity to reflect it had been dealt with, and then create a new activity for the next renewal.  
  
  ---
  
  