title: find common data between two dataframes on a specific range of date
body: <p>I have two dataframes df1 and df2 based, respectively, on these dictionaries:</p>
  <pre class="lang-py prettyprint-override"><code>data1 = {'date':  ['5/09/22', '7/09/22', '7/09/22','10/09/22'],
              'second_column': ['first_value', 'second_value', 'third_value','fourth_value'],
               'id_number':['AA576bdk89', 'GG6jabkhd589', 'BXV6jabd589','BXzadzd589'],
              'fourth_column':['first_value', 'second_value', 'third_value','fourth_value'],}
      
  data2 = {'date':  ['5/09/22', '7/09/22', '7/09/22', '7/09/22', '7/09/22', '11/09/22'],
              'second_column': ['first_value', 'second_value', 'third_value','fourth_value', 'fifth_value','sixth_value'],
               'id_number':['AA576bdk89', 'GG6jabkhd589', 'BXV6jabd589','BXV6mkjdd589','GGdbkz589', 'BXhshhsd589'],
              'fourth_column':['first_value', 'second_value', 'third_value','fourth_value', 'fifth_value','sixth_value'],}
  </code></pre>
  <p>I want to compare df2 with df1 in order to show the &quot;id_number&quot; of df2 that are in df1.</p>
  <p>I also want to compare the two dataframes on the same date range.</p>
  <p>For example the shared date range between df1 and df2 should be the from 5/09/22 to 10/09/22 (and not beyond)</p>
  <p>How can I do this?</p>