change plan from 1 year to fixed date expiry

Hi Guys

We have a plan which has always had a subscription length of 1 year from the time of purchase/renewal.  
We now want to change this plan so that all memberships expire on 30th June each year so that everyone renews at the same time.

How can I achieve this change with a current plan with many members.

I have attached the current set up for your reference
 

Thanks
Alison

I guess you would have to run an SQL command to your database

Maybe should only update subscription end date of active subscribers only ?

UPDATE #__osmembership_subscribers SET to_date = "2021-06-30" WHERE published = 1 AND YEAR('to_date') = 2021

(Replace #__osmembership_subscribers with the actual table on your site, depends on table prefix)

Regards,

Tuan