Please have a look at this document. www.ramtinworld.com/expired.jpg

All the expired memberships still have Active as status.

So I am not sure how I can filter by expired when the status is active?

I appreciate your help.

As per your previous instructions we used SQL actions and we set this up when we went live with the module.

sorry I think I kind of understand your response, but I am confused as well.

Our memberships will expired end of each June (end of fiscal year in Australia) and it really doesn't matter when the members sign up.

So since there is no way to make this happen under the standard plan section, your team suggested that we use SQL actions to force expiry end of June each year.

Is there a way to fix this really now?

And I dont really understand this section of your response:

Also the auto-expiration method chosen in global settings of cbsubs should be triggered for the real expiry to happen. By default that happens automatically. But if you set it to cron job and don't setup a cron job, it won't happen.