My client's organization has Memberships that expire on October 31st every year.

The "Calendar Year" Series of Plan Options would work if I could get the end of the Calendar year to become October 31st.

Does anyone know of a way to make this happen?

Thanks for the excellent reply and links.

I was planning on manually altering those dates with phpmyadmin, but your method sounds better.

It certainly would make a great feature request, as I am sure many organizations have membership expire dates that occur at a specified date each year.

What do you think the chances are of (and the cost of) getting a modification to do this by the folks at joomapolis?

Please let me know the progress of this!! It will make my life much easier when dealing with my client's Membership Chair and Board of Directors.

In the short term, I added a SQL action:

UPDATE `jos_cbsubs_subscriptions` SET `expiry_date` = '2011-11-01' WHERE `user_id` = [user_id] AND `plan_id` = [plan_id] AND `status` = 'A'

I added this to the "Activation" Action, plus on the renewal action I added:

UPDATE `jos_cbsubs_subscriptions` SET `expiry_date` = '2012-11-01' WHERE `user_id` = [user_id] AND `plan_id` = [plan_id] AND `status` = 'A'

(The only difference is that the year is 2012 on that one.)

ONE PROBLEM >>>>> When I hit "Save" I got a 403 error "Attempted SQL injection in POST"

I resorted to first saving the Integration using a bogus database name (altered by one letter), then using PHPMyAdmin I edited the SQL plans table and inserted the correct database name.

Tomorrow my client adds a new user, so we'll see if it works.

Thought you should be aware of the error, though.

Can't wait for the feature update in the core product!!!

Thanks!