title: sql get data where date is greater than current month
body: <p>i want to retrieve records where a date field is set to future months </p>
  
  <p>does this look correct</p>
  
  <pre><code>Select * from table1 WHERE
   datesetto &gt;MONTH(dateadd(dd, -1, GetDate())))  
  </code></pre>