Answers.Body: <p>Have you tried using Search Kit?</p>
  <p><a href="https://i.sstatic.net/4zP6X.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/4zP6X.png" alt="enter image description here" /></a></p>
  <p>Code:</p>
  <pre><code>[
    [
      &quot;SavedSearch&quot;,
      &quot;save&quot;,
      {
        &quot;records&quot;: [
          {
            &quot;name&quot;: &quot;Last_4_month&quot;,
            &quot;label&quot;: &quot;Last 4 month&quot;,
            &quot;form_values&quot;: null,
            &quot;mapping_id&quot;: null,
            &quot;search_custom_id&quot;: null,
            &quot;api_entity&quot;: &quot;Membership&quot;,
            &quot;api_params&quot;: {
              &quot;version&quot;: 4,
              &quot;select&quot;: [
                &quot;id&quot;,
                &quot;Membership_Contact_contact_id_01.display_name&quot;,
                &quot;end_date&quot;
              ],
              &quot;orderBy&quot;: [],
              &quot;where&quot;: [
                [
                  &quot;end_date&quot;,
                  &quot;&lt;=&quot;,
                  &quot;now - 4 month&quot;
                ]
              ],
              &quot;groupBy&quot;: [],
              &quot;join&quot;: [
                [
                  &quot;Contact AS Membership_Contact_contact_id_01&quot;,
                  &quot;LEFT&quot;,
                  [
                    &quot;contact_id&quot;,
                    &quot;=&quot;,
                    &quot;Membership_Contact_contact_id_01.id&quot;
                  ]
                ]
              ],
              &quot;having&quot;: []
            },
            &quot;expires_date&quot;: null,
            &quot;description&quot;: null
          }
        ],
        &quot;match&quot;: [
          &quot;name&quot;
        ]
      }
    ]
  ]
  </code></pre>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-10-24T16:20:58.487Z
Answers.LastActivityDate: 2022-10-24T16:20:58.487Z
Answers.UserDisplayName: Pradeep Nayak
Body: <p>We have civi 5.53 and Wordpress.</p>
  <p>I am wanting to deal with overdue memberships.  We have an end date of the last day of the month.  Start date doesn't work for us so using end date.</p>
  <p>I can use the option for month before previous month to get all our 30 day overdues.  I would like to be able to find all those end dates for membership that are 3 months and 4 months over due.</p>
  <p>I'm wanting this to be an automatic search - so whilst I can do this manually does anyone know how I could do this so that I can save a report with the criteria in for 3 months and 4 months ago?</p>
  
Tags: <civimember><search>
Title: Search by 4 months ago on Membership
ThreadText: # Search by 4 months ago on Membership
  
  (Asked by: username_0 on 2022-10-24)
  
  We have civi 5.53 and Wordpress.
  
  I am wanting to deal with overdue memberships. We have an end date of the last day of the month. Start date doesn't work for us so using end date.
  
  I can use the option for month before previous month to get all our 30 day overdues. I would like to be able to find all those end dates for membership that are 3 months and 4 months over due.
  
  I'm wanting this to be an automatic search - so whilst I can do this manually does anyone know how I could do this so that I can save a report with the criteria in for 3 months and 4 months ago?
  
  **Tags:** civimember, search
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2022-10-24. Score: 2 | Accepted answer
  
  Have you tried using Search Kit?
  
  [![enter image description here](https://i.sstatic.net/4zP6X.png)](https://i.sstatic.net/4zP6X.png)
  
  Code:
  
  ```
  [
    [
      "SavedSearch",
      "save",
      {
        "records": [
          {
            "name": "Last_4_month",
            "label": "Last 4 month",
            "form_values": null,
            "mapping_id": null,
            "search_custom_id": null,
            "api_entity": "Membership",
            "api_params": {
              "version": 4,
              "select": [
                "id",
                "Membership_Contact_contact_id_01.display_name",
                "end_date"
              ],
              "orderBy": [],
              "where": [
                [
                  "end_date",
                  "<=",
                  "now - 4 month"
                ]
              ],
              "groupBy": [],
              "join": [
                [
                  "Contact AS Membership_Contact_contact_id_01",
                  "LEFT",
                  [
                    "contact_id",
                    "=",
                    "Membership_Contact_contact_id_01.id"
                  ]
                ]
              ],
              "having": []
            },
            "expires_date": null,
            "description": null
          }
        ],
        "match": [
          "name"
        ]
      }
    ]
  ]
  
  ```
  
  
  ---
  
  