title: How to select a data access database filtering with the months of the date?
body: <p>I want to select the row of a database when the month of a date is accurate. for the year I did it:
  <code>select * from table where YEAR(date)='2015'</code>  it works well for the years</p>
  
  <p>for the months I made : </p>
  
  <pre><code>select * from table where Month(date)='01'// I have the date format dd/mm/yyyy
  </code></pre>
  
  <p>thanks</p>