title: how to write a where clause in sql query where I need to compare date field with current time?
body: <p>I have three variables
  1. Start Date (column in a table)
  2. Current Date
  3. Start Date + 1 week</p>
  
  <p>I want to write a where clause in  sql query in such a way that</p>
  
  <p>Current Date should be between Start Date and (Start Date + 1 week)
  and Current Date can be less than Start Date but 
  not greater than (Start Date + 1 week )</p>