My website's subscription period runs from 1 June to 31 May, regardless of when the member subscribes. This is not available by default so I suppose I will have to use some SQL integration actions to modify the expiry.
As per advice from Beat, I have used a yearly NON-calendar setting for this plan, so now I need an SQL action query to change the expiry_date in jos_cbsubs_subscriptions to the 31 May preceding the date which gets computed automatically.
Can anyone help or at least give me some pointers on how to develop this query?
Thanks in advance!