We are currently trying to sort our subscriber database so we can see who has birthdays this month, and whose membership will expire in the coming month.

However, we have found that trying to use the search filters does not work. This appears to be because the sort filter is looking for the next 30 days this year - not the next 30 days of any year.

Is there any way to fix this? Currently our admin team is having to repeatedly export the db to Excel and then use Excel's sorting to find the relevant figures.