title: SQL where Date from today minus and plus days
body: <p>I have codes like this:</p>
  
  <pre><code>  select CUS_Id, CUS_Name, CUS_JoinDate
  
    from CUSTOMER
  
    where CUS_joinDate between '04-12-2013' and '06-12-2013'
  </code></pre>
  
  <p>How can I make it 'where' CUS_JoinDate will be declare as from Today Date(minus 1 month and today + 1 month)?</p>
  
  <p>So every time I run the report it will depends on the current date and it will automatically minus and plus 30 days.</p>