title: Finding all items in column1 that matches "DATE" in column2 throught the years
body: <p>I would like to write a select statement where the output will return all the records that both (or more?) matches the date dd.mm (with an error margin of +5 days and -5 days from a specific date)
  I mean date dd.mm with 5+- days difference, so records from past years but what they got in common is the similar dd.mm
  the main condition is that both persons must match the dates more than one year for example in 2018 and 2019</p>
  <p>to better imagine this situation we can assume that this is logging records and I would like to find out which 2 persons logged in in nearly the same date (with that 5+- days difference) in last years</p>
  <p>example:
  TABLE</p>
  <pre><code>id  person  date
  1   John    01.12.2019
  2   Mike    01.12.2019
  3   Bruce   02.11.2019
  4   Lee     02.11.2019
  5   John    03.05.2018
  ......................
  ......................
  556 Mike    03.05.2018
  557 Bruce   02.11.2017
  558 Lee     01.11.2017
  559 John    01.12.2017
  </code></pre>
  <p>RESULTS I WANT</p>
  <pre><code>id  person  date
  3   Bruce   02.11.2019
  4   Lee     02.11.2019
  ......................
  ......................
  557 Bruce   02.11.2017
  558 Lee     01.11.2017
  </code></pre>
  <p>thanks to that return i will be able to see a pattern which names done some action in similar time in the past.</p>
  <p><a href="https://i.stack.imgur.com/Y5T7K.png" rel="nofollow noreferrer">possible return of query</a></p>