title: SQL Server : create future dates
body: <p>How do I create future dates in SQL? For example, I want to be able to use my date range and show everything for just next month (purchase orders), then another for two months out, etc. I have used the fn NOW() for the current date/time but this doesn't help me at all for showing records for next month, etc. </p>
  
  <p>Thanks</p>
  
  <p>This is for a SQL query that in doing in SQL Server 2008 R2. </p>