title: Function Year and MONTH for GetDate();
body: <p>please can you help me with my problem? So i have problem that i must search some data for some time but evertime return me diferent value. </p>
  
  <pre><code>// This return me 10k values
  YEAR(pol.datum) &gt;= YEAR(GETDATE()) - 1 and YEAR(pol.datum) &lt;= YEAR(GETDATE())
  
  // This return me 14k values 
  YEAR(pol.datum) = YEAR(GETDATE()) and MONTH(pol.datum) &lt;= MONTH(GETDATE()) - 1 and MONTH(pol.datum) &gt;= MONTH(GETDATE()) - 7
  
  // this return me 16k value
  YEAR(pol.datum) = YEAR(GETDATE()) and MONTH(pol.datum) &gt;= MONTH(GETDATE()) - 4 and MONTH(pol.datum) &lt;= MONTH(GETDATE()) - 1
  </code></pre>
  
  <p>Can you tell me why it return me more value for some months than after all year</p>