title: Search dates on a record
body: <p>I'm storing dates on MS ACCESS database along with other information. But I can't seem to search them as I please. I'd like to search by: year, month. I'm using a <code>datetimepicker</code></p>
  
  <p>Currently I'm using this code to do so: 
      <code>ADOTable1.Filter := 'Date &gt; ' +
      Edit1.Text;
     ADOTable1.Filtered := True;
  end;</code></p>
  
  <p>Could anyone help me?</p>