Answers.Body: <p>You may have to amend the 'end dates' that are on those old style memberships either </p>
  
  <ul>
  <li><p>via SQL</p></li>
  <li><p>manually in the DB</p></li>
  <li><p>via a Batch Update of Memberships</p></li>
  <li><p>export Membership data and reimport it (as per JoAnne's answer - added here to include in this list)</p></li>
  </ul>
  
  <p>Which option suits you may depend on your skills and the number of memberships involved.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-04-03T00:22:09.070Z
Answers.LastActivityDate: 2016-04-03T08:46:00.963Z
Answers.LastEditDate: 2016-04-03T08:46:00.963Z
Answers.UserDisplayName: petednz - fuzion
Answers.Body: <p>You haven't given enough detail in your question but I will have a go at answering what I think is your question.</p>
  
  <p>You say
   "Now i have updated membership type to 1 year expiration".</p>
  
  <p>I am taking that at face value, ie your membership type called "our membership" did have a duration of 2 years but has been updated so that it now has a duration of 1 year. (If instead you have created a <strong>new</strong> membership type of one year duration then what follows is irrelevant to your situation.) </p>
  
  <p>If these are paid memberships, then I would expect that the existing expiry dates should stand but when members renew they should only get an 12 month extension to their membership end date. That would be normal CiviCRM behaviour, so I have ot assume that is not your situation.</p>
  
  <p>That suggests that these are free memberships and you want <strong>alter</strong> the expiry date of the existing memberships.  That seems a little out of the ordinary. I am not sure I would be happy if an organisation said to me "Yes, we know we said your membership expires on 31 December 2017, but we changed our minds and now it expires on 31 December 2016".</p>
  
  <p>Still, if that is what you want to do, you need to realise that the end date of a membership is fixed when the membership is created, so you will have to change the existing end dates.</p>
  
  <p>I would do it by exporting the membership data, altering the end dates in a spreadsheet then importing the membership data with the new end dates.</p>
  
  <p>When you export the membership data I suggest you export  membership Id, membership type, membership status, member since date (or is it "membership join date"), membership start date and membership end date. The importer always needs more fields than I think it should, so it is better to be get all those fields out in just one export.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-04-04T04:19:50.270Z
Answers.Text: Thank you. Problem Solved by doing export changing end date and reimporting. You guys are awesome. Thanks JoAnne and PeteDNZ
Answers.UserDisplayName: adizo
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-04-03T00:36:36.440Z
Answers.LastActivityDate: 2016-04-03T00:36:36.440Z
Answers.UserDisplayName: JoAnne
Body: <p>i have a set of membership records set to expire every two years. So i have a lot of members whose expiry date is set to 2 years.</p>
  
  <p>Now i have updated membership type to 1 year expiration. I find that only new members inherit the new expiry date but not the old records. How can i update the old records membership to reflect the changes.</p>
  
Tags: <civimember><upgrade>
Title: How To Apply Membership Type Update To Existing Records
ThreadText: # How To Apply Membership Type Update To Existing Records
  
  (Asked by: username_0 on 2016-04-02)
  
  i have a set of membership records set to expire every two years. So i have a lot of members whose expiry date is set to 2 years.
  
  Now i have updated membership type to 1 year expiration. I find that only new members inherit the new expiry date but not the old records. How can i update the old records membership to reflect the changes.
  
  **Tags:** civimember, upgrade
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_1 on 2016-04-03. Score: 2
  
  You may have to amend the 'end dates' that are on those old style memberships either
  
  * via SQL
  * manually in the DB
  * via a Batch Update of Memberships
  * export Membership data and reimport it (as per username_2's answer - added here to include in this list)
  
  Which option suits you may depend on your skills and the number of memberships involved.
  
  
  ---
  
  ### Answer by username_2 on 2016-04-03. Score: 2
  
  You haven't given enough detail in your question but I will have a go at answering what I think is your question.
  
  You say
  "Now i have updated membership type to 1 year expiration".
  
  I am taking that at face value, ie your membership type called "our membership" did have a duration of 2 years but has been updated so that it now has a duration of 1 year. (If instead you have created a **new** membership type of one year duration then what follows is irrelevant to your situation.)
  
  If these are paid memberships, then I would expect that the existing expiry dates should stand but when members renew they should only get an 12 month extension to their membership end date. That would be normal CiviCRM behaviour, so I have ot assume that is not your situation.
  
  That suggests that these are free memberships and you want **alter** the expiry date of the existing memberships. That seems a little out of the ordinary. I am not sure I would be happy if an organisation said to me "Yes, we know we said your membership expires on 31 December 2017, but we changed our minds and now it expires on 31 December 2016".
  
  Still, if that is what you want to do, you need to realise that the end date of a membership is fixed when the membership is created, so you will have to change the existing end dates.
  
  I would do it by exporting the membership data, altering the end dates in a spreadsheet then importing the membership data with the new end dates.
  
  When you export the membership data I suggest you export membership Id, membership type, membership status, member since date (or is it "membership join date"), membership start date and membership end date. The importer always needs more fields than I think it should, so it is better to be get all those fields out in just one export.
  
  > **Comments:**
  > **username_0**: Thank you. Problem Solved by doing export changing end date and reimporting. You guys are awesome. Thanks username_2 and PeteDNZ  
  
  ---
  
  