title: Find Customers who have birthdays in next 7 days in laravel
body: <p>I need to get list of Customers who have birthdays in next 7 days in laravel. i using following query. that query display passed birthdays also.</p>
  
  <pre><code> $customerslist=Customers::WhereRaw('DAYOFYEAR(curdate()) &lt;= DAYOFYEAR(date_of_birth) AND DAYOFYEAR(curdate()) + 7 &gt;=  dayofyear(date_of_birth)' )-&gt;OrderBy(DB::raw("DAYOFYEAR(date_of_birth)"),'ASC')-&gt;get();
  </code></pre>
  
  <p>i use below query listed following but missing some customers
  <a href="https://i.stack.imgur.com/MWa5k.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/MWa5k.png" alt="enter image description here"></a></p>
  
  <p>Missing Customer</p>
  
  <p><a href="https://i.stack.imgur.com/UQbQE.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/UQbQE.png" alt="enter image description here"></a></p>