title: Creating a list of custom Date Ranges for ease of use, in SQL Server
body: <p>Given a date (such as today's date, &quot;October 8th, 2020&quot;) and a list of date ranges (Yesterday, Tomorrow, Last Week, Next Week, Last Month, Next Month, etc.), how can we arrive at the necessary date ranges, via SQL.</p>
  <pre><code>Yesterday   2020-10-07 00:00:00.000 2020-10-07 23:59:59.000
  Tomorrow    2020-10-09 00:00:00.000 2020-10-09 23:59:59.000
  Last Week   2020-09-27 00:00:00.000 2020-10-03 23:59:59.000
  Next Week   2020-10-11 00:00:00.000 2020-10-17 23:59:59.000
  Last Month  2020-09-01 00:00:00.000 2020-09-30 23:59:59.000
  Next Month  2020-11-01 00:00:00.000 2020-11-30 23:59:59.000
  </code></pre>