title: MySQL query to exclude a range of dates not working
body: <p>I have a dataset that includes the booking_date field stored as 2021-08-31.  I need to run a query that excludes all dates further forward than a specific range ie today +7.</p>
  <p>Using:</p>
  <pre><code>SELECT *
  FROM work_jobs
  WHERE (cast(booking_date as date)  NOT BETWEEN DATE_ADD(cast(NOW() as date), INTERVAL 1 DAY) AND NOW()) AND job_closed = 0 ORDER BY booking_date ASC;
  </code></pre>
  <p>does not work.  The full dataset with dates in the future is returned.</p>
  <p>Any suggestions?  Many thanks in advance.</p>