How do I filter for users that have a product that expires on a specific date, but did not purchase a renewal. The way all of our renewals work, the end date is always April 1st and the new product starts on April 1st and goes for a year. If we filter for people who have a product expiring on April 1st, 2017, it still shows the people that already purchased their renewal and have a future product for April 1st, 2017-April 1st 2018. I need to know how to remove everyone who expires on April 1st 2017, but doesn't have a product that expires after that. Basically, I'd like to filter on the final Expire date that shows in the browse user window.
Hello, I believe it is possible to implement custom search criteria for advanced user search. Do you mind to contact us in helpdesk? https://www.amember.com/support Best Regards.