Answers.Body: <p>The error message shows future start and join dates.  Civi is attempting to the determine the status as of the time of import, but none of the default status rules cover that scenario hence the error message.  'New' only applies from the 'member since' / 'join date' so is not applicable.</p>
  
  <p>One option is to change your join dates to be the current time so that the memberships show as 'New'.  Your memberships would then be regarded as 'current' despite being before the membership start date.</p>
  
  <p>Alternatively, you could create a 'future' status with start event of 'start date' with eg a '-1 month' adjustment, and an end date of 'start date'.  That should let you import the membership which will be inactive until the start date is reached.  (Not tested extensively but seems to work on a quick test.)</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-06-20T09:17:12.850Z
Answers.LastActivityDate: 2019-06-20T09:17:12.850Z
Answers.UserDisplayName: Aidan
Body: <p>I have read the related thread and tried many iterations to find a solution for the error </p>
  
  <blockquote>
    <p>The membership cannot be saved because the status cannot be calculated for start_date: 20190701 end_date 20200630 join_date 20190701 as at 2019-06-18 07:16:08</p>
  </blockquote>
  
  <p>I know a lot has been written on this but none of it is working to solve my problem.  I apologize if I am missing something simple.  I am running 5.13.14 in Drupal 7 using PHP 7.2. </p>
  
  <p>I am trying to import members with a contact ID, start date, and membership type ID.  I have tried using an end date as well but that does not help.  </p>
  
  <p>Here are my membership rules.  </p>
  
  <p><strong>New</strong>
  <a href="https://i.sstatic.net/v3S5t.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/v3S5t.png" alt="enter image description here"></a></p>
  
  <p><strong>Current</strong>
  <a href="https://i.sstatic.net/3L3Dt.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/3L3Dt.png" alt="enter image description here"></a></p>
  
  <p><strong>Grace</strong>
  <a href="https://i.sstatic.net/arwCF.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/arwCF.png" alt="enter image description here"></a></p>
  
  <p>Any help in figuring out what is wrong here is greatly appreciated!</p>
  
  <p>Thanks,
  Josh</p>
  
Tags: <civimember>
Title: Cannot Find Solution For “Membership status cannot be calculated for <dates>” Renewal Error!
ThreadText: # Cannot Find Solution For “Membership status cannot be calculated for <dates>” Renewal Error!
  
  (Asked by: username_0 on 2019-06-20)
  
  I have read the related thread and tried many iterations to find a solution for the error
  
  > The membership cannot be saved because the status cannot be calculated for start\_date: 20190701 end\_date 20200630 join\_date 20190701 as at 2019-06-18 07:16:08
  
  I know a lot has been written on this but none of it is working to solve my problem. I apologize if I am missing something simple. I am running 5.13.14 in Drupal 7 using PHP 7.2.
  
  I am trying to import members with a contact ID, start date, and membership type ID. I have tried using an end date as well but that does not help.
  
  Here are my membership rules.
  
  **New**
  [![enter image description here](https://i.sstatic.net/v3S5t.png)](https://i.sstatic.net/v3S5t.png)
  
  **Current**
  [![enter image description here](https://i.sstatic.net/3L3Dt.png)](https://i.sstatic.net/3L3Dt.png)
  
  **Grace**
  [![enter image description here](https://i.sstatic.net/arwCF.png)](https://i.sstatic.net/arwCF.png)
  
  Any help in figuring out what is wrong here is greatly appreciated!
  
  Thanks,
  username_0
  
  **Tags:** civimember
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2019-06-20. Score: 2
  
  The error message shows future start and join dates. Civi is attempting to the determine the status as of the time of import, but none of the default status rules cover that scenario hence the error message. 'New' only applies from the 'member since' / 'join date' so is not applicable.
  
  One option is to change your join dates to be the current time so that the memberships show as 'New'. Your memberships would then be regarded as 'current' despite being before the membership start date.
  
  Alternatively, you could create a 'future' status with start event of 'start date' with eg a '-1 month' adjustment, and an end date of 'start date'. That should let you import the membership which will be inactive until the start date is reached. (Not tested extensively but seems to work on a quick test.)
  
  
  ---
  
  