CiviCRM Community Forums (archive)

Hi,

This may be very simple but I have searched using google on the forums and not had any luck.

I would like to create an advanced search using

Contibution Status = "New" and/or "Pending"
Membership Start Date = "Next Week" (or possibly also "Next Month", "next quarter" etc)

So far I have created a similar search by using "This Month". Once I chose Display Results As "Memberships" I got the whole month which is great, but that can't be turned into a Smart Group as its member based afaik.

Ultimately I would like to create a Smart Group based on this, just as we have for Memberships finishing "This Week". We run a school and our Members are in fact students arriving. Every week we need to know how many will arrive the following Monday in order to get teachers / classroom space etc.

Or perhaps something like this can be done in a Report?  Just so long as it adds dates dynamically - x days from now or the above "next week" type of token / variable.

Thanks for your help!

(Drupal 6 // CiviCRM 4.2.0)