title: Laravel compare string date in database with carbon date
body: <p>I have made a mistake by storing the date as VARCHAR in the database and here it looks like <strong>02/12/2018</strong> and I have created a variable using carbon to get the current date <strong>+14 days</strong>.</p>
  
  <p><code>$current_date_plus_14   = Carbon::now() -&gt; addDay(14) -&gt; format('d/m/Y');</code></p>
  
  <p><strong>Problem is</strong></p>
  
  <p>I am trying to compare this date <strong>02/12/2018</strong> which is in the database and stores as VARCHAR to the date that I have generated using Carbon which is <strong>09/04/2017</strong>.</p>
  
  <p><strong>Eloquent Code</strong></p>
  
  <p><code>$gquery = Client::where('required_date', '&gt;=', $current_date_plus_14) -&gt; get();</code></p>
  
  <p><strong>What I get</strong></p>
  
  <p>It doesn't get any results because it compare only the day in the <strong>required_date</strong> and the day in the <strong>carbon date</strong>.</p>
  
  <p>While it should return value because the there is more than 1 year difference?</p>