title: Multiple statements in a where clause
body: <p>I'm trying to create a where clause that has 2 statements that work together and then a separate statement that works by itself if it meets a certain criteria</p>
  
  <p>I've tried CASE statements, AND's, OR's and still nothing works</p>
  
  <pre><code>WHERE HB.CreatedByDate = @ReportDateN AND HB.Date = @ReportDateN - 1
  </code></pre>
  
  <p>So this code is my current where clause that get's me results that have the CreatedByDate equal to the variable @ReportDateN but also have the regular date equal to the variable @ReportDateN except it minuses one day.</p>
  
  <p>This by itself does what I want it to do but I'd like to add some more.</p>
  
  <p>I want to make it so if a variable called @WeekDay = 'Monday' then to subtract 3 from @ReportDateN in the second part instead of just 1.</p>
  
  <p>Any help will be appreciated, thanks!</p>