Krileon,
I really appreciate the response. I think what I'm looking for wouldn't update a user's expiration date on a new subscription (as I need to import a number of users and adjust some dates in there) manually.

For example, if I import a user and need to set their registration date to 4/10/2005, would I be switching that within the Community Builder user database or in the Joomla! user database (I looked at the database and saw that field in jos_users, but not jos_comprofiler - but I do want to be 100% sure)?

Also, if I want to go into PHPmyAdmin (as well as the first one) and switch when their subscription starts and ends, where exactly would I go for that?

For example, I see a jos_cbsubs_subscriptions table, where I could probably edit those dates, is that the best place to do that? Would the 'last renew' and and 'subscription date' probably be set to the same?

I realize this way is doing everything manual, but if I can make sure everything will be put in correctly (since after this initial import the new subscriptions will take care of themselves) then it'd be great.

Again, I really appreciate your insight on this and am very grateful for CBSubs and Community Builder!

Krileon,
Thank you very much! I had no idea that 'ID' field in CB Subs would let me adjust that outside the database.

If I only have to go into the database to adjust the registration date (in jos_users) and then I can just manually add each user to a subscription/membership level, and then just click on each one and update the dates, that works perfectly!

Again, if I'm over excited because I'm saying something wrong up there please feel free to jump-in ha, but thank you!

Its that time of year for me to deal with expiry dates and I wanted to use the SQL actions again to force expiry dates.

My question is I have some members whose status is "Expired" Can you tell me how I force a specific date based on that status, similar to what was done as mentioned earlier in this thread:

The code I imagine I will use is similar to this.

So my questions:

Do I simply change the 'status = 'A' to 'E' to trigger this SQL action?

Do I place this in the SQL Actions labeled "expiration" or add in the Activation box along wit the existing code?

Right now I have code in the Activation and Renewal boxes, but those renewal dates are different.

In essence, what I am trying to accomplish is the following:

Active members who renew will have an expiry date of 2013-10-01
Expired members will have an expiry date of 2012-10-01

This means that expired members have to pay for this years membership period before renewing for next year's membership period.

My logic is that the SQL actions will be a two step process for an expired members - I'm hoping
The 'Expired' SQL Action will trigger first (2012) after which they become "Active". When they go to renew a second time the 'Active status' SQL action will trigger (2013).

Does this make sense? Am I on the right track?

Just discovered the "E' should be an 'X'

Here's a few more things I've discovered.

When an expired membership goes to renew it's called "Reactivate" - I'm not sure how this plays out when I'm trying to force the 2012 expiration date (i.e. how the SQL Action code will differ)

An Active member indicated "renew now". Since the date of the active member is already set up accurately, I do not need to force the date. In this case, I presume I do not need to worry about an SQL action.

Hoping someone can help!