Using SQL Action To Force Expiry Dates

The SQL Action works no problem for new members (In the activation box)

The Renewal box has been left blank as any active member now all already have expiry dates set to 2012-09-30. I am assuming when I permit early renewals (already set at 1 year) that the expiry date will be accurate 2013-09-30.

The issue I'm only really having is those that have EXPIRED. They need to first renew until 2012-09-30 before being able to extend the membership to next year 2012-10-01 to 2013-09-30.

With CBSubs 2.02, can I change the plan if members are already part of it?

Incidentally - I have no option but to keep the renewal date as is (October 1 - September 30).

The issue I'm only really having is those that have EXPIRED. They need to first renew until 2012-09-30 before being able to extend the membership to next year 2012-10-01 to 2013-09-30.

I don't think you can do that. That'd require a query on the renewal action, but that'd apply to all renewals.

With CBSubs 2.02, can I change the plan if members are already part of it?

Please be more specific on what you intend to change. Changing duration will have no affect on those already actively subscribed.