title: Is there a way to use the dateadd() in the where clause in a between statement?
body: <p>Here's my problem.</p>
  
  <p>In my <code>where</code> clause I am trying to use the <code>between</code> clause with dates. In the second date I add, I need it to return the day after the date that is being input.</p>
  
  <p>For example: <code>where DATE between '2015-05-01' and '2015-05-31'</code> is what I would like the user to input, but I would like the database to read it as <code>where DATE between '2015-05-01' and '2015-06-01'</code></p>
  
  <p>I have tried:
  <code>where DATE between '2015-05-01' and dateadd('d', 1, '2015-05-31')</code></p>
  
  <p>which obviously gives my a syntax error. I have also tried to use a sub query, which also did not work.</p>
  
  <p>Does anyone have any ideas or suggestions that would help? Or is this not possible in SQL? Any advice would be much appreciated!</p>
  
  <p>Thanks! </p>