I want to setup a plan matching our financial year. So all members need to be setup to have expiry date of June 1st every year, irrespective of when they bought the subscription.

Is there a way to setup on CB Subs a particular expiry date. Is there some hack available as I cannot see in plan listing anything like that.

This is something that I requested during the beta program, but I don't think it has made it into the product yet.

I think that one workaround that was posted was to force the plan expiration date to the specific value you want using a SQL action during activation. But that doesn't seem to handle pro-rating, etc. which you would likely want.

I hope that maybe this gives you a start while waiting for an official solution.

Best,
Ken

I use the following sql-statement on plan activation:

update jos_cbsubs_subscriptions set expiry_date=STR_TO_DATE(concat('31.03.',YEAR(NOW())+1, '23:59:00'),'%d.%m.%Y %k:%i:%s') where user_id=[user_id];

With this statement the plan expires 31.3 "next year".

But can it be for a different period, or just the calendar year. IE: our calendar year and bi-monthly payments are based on our fiscal year (Nov.1-Oct.31)

This has been an open issue since early in the Beta period.

You'll probably have to use a SQL action, as above, to set the expiration date.

If you come up with a good solution, please post back.

K