Hi Joe

We have purchased Site Membership Pro for use on a client site and the role granting functionality etc is just what we need.

We are using it to support an annual membership product that expires on a fixed date each year for all members.  (Ie when a member joins for the first year their fee gives them access for the remainder of the membership year and subsequent renewals then give them 365 day access.)

From what I can see, this isn’t directly supported in SMP however we are proposing to achieve this by using a “Year 1” membership product whose duration is reduced each day so that all new subscribers are given the same calendar end date.  They will then renew using another standard 365 day duration product.

We are proposing to use a stored procedure to regularly update the DurationInDays field in sts_MembershipProduct to achieve this.

Aside from future structure changes, can you see any general problems with this approach that would prevent it working?

Many thanks

Neil

Thanks Joe - That's a great help.

Neil