How can I setup a Smart Group to include members based on relative dates (e.g. last Activity)?

When I try to use relative date, e.g. Yesterday in advanced search, it correctly finds users with Activity on previous day, but when I create a Smart Group out of that search, it seems to fix the date in search criteria. As a result the next day smart group now contains members with Activity on the day before yesterday.

Neither running Rebuild Smart Group Cache (no parameters) nor clicking Update Smart Group Counts helped.

Am I missing something obvious?

Wordpress: 4.5.3 CiviCRM: 4.7.9

enter image description here

Tried to create a Smart Group in CiviCRM Sandbox on Drupal and it seems Activity Date gets fixed immediately when trying to create a Smart Group from Advanced Search. enter image description here

  • 2
    Your query is similar to this question although because the author had stated their intentions they were able to get a workaround. You're correct that the search and smart group function doesn't keep the smart group dates as a relative search and instead translates it but, if you're able to, could you expand on your question and let people know what you're trying to achieve?
    – Matt Lind
    Commented Aug 18, 2016 at 13:18
  • @MattLind I am afraid that the scale of my intentions will prohibit simple workaround. I'd like to create multiple smart groups in such a way that a contact is changing the groups (depending on the relative time of activities).
    – Aivars
    Commented Aug 18, 2016 at 14:00
  • 1
    Sounds fun =) What will you be looking to do with the contacts when they are in the different smart groups? e.g. If it's just a case of seeing people's relative time from an activitiy then reports might be a better place to look.
    – Matt Lind
    Commented Aug 18, 2016 at 15:10
  • I'd like to use multiple parameters for filtering users. E.g. Group A: Activity X, if before 30 days. Group B: Activity X, if during last 30 days. Group C: Activity Y, if before 14 days. Group D: Activity Y, if during 14 days. It is not that I'd like to only see relative time of all people. I'd rather like to see people in different categories, depending on multiple parameters (often 3 or 4), so that I can meaningfully interact with each category.
    – Aivars
    Commented Aug 18, 2016 at 15:12

1 Answer 1


This was a bug in Core CiviCRM which is now fixed starting from version 4.7.14.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.