How To Get Data Between Two Dates In Laravel 9

Websolutionstuff | Dec-19-2022 | Categories : Laravel MySQL

In this article, we will see how to get data between two dates in laravel 9. Here we will learn how to count days between two dates in laravel 8/9. You can use a different method to get data between two dates in laravel 7, laravel 8, and laravel 9.

We will use carbon for the date and time to parse the date in laravel 9. Carbon is a simple API extension of DateTime. Carbon makes it easy to get a Date and Time. Also, Carbon provides multiple methods to get data like today's date, yesterday's date, and many other methods to get dates, months, and years.

So, let's see how to get data between two dates in laravel 8/9 and laravel 9 carbon to get the number of days between the two dates.

Example 1: Count Days Between Two Dates in Laravel

In this example, we will count the days between two dates using carbon.

<?php
  
namespace App\Http\Controllers;
  
use Illuminate\Http\Request;
use Carbon\Carbon;
  
class DateController extends Controller
{
    public function index(Request $request)
    {
        $toDate = Carbon::parse("2022-11-26");
        $fromDate = Carbon::parse("2022-11-28");
  
        return $toDate->diffInDays($fromDate);  
    }
}

 

Example 2: Count Months Between Two Dates in Laravel

In this example, we will count the months between two dates using carbon.

<?php
  
namespace App\Http\Controllers;
  
use Illuminate\Http\Request;
use Carbon\Carbon;
  
class DateController extends Controller
{
    public function index(Request $request)
    {
        $toDate = Carbon::parse("2022-06-06");
        $fromDate = Carbon::parse("2022-11-06");
  
        return $toDate->diffInMonths($fromDate);  
    }
}

 

 

Example 3: Count Years Between Two Dates in Laravel

In this example, we will count the years between two dates using carbon.

<?php
  
namespace App\Http\Controllers;
  
use Illuminate\Http\Request;
use Carbon\Carbon;
  
class DateController extends Controller
{
    public function index(Request $request)
    {
        $toDate = Carbon::parse("2020-02-07");
        $fromDate = Carbon::parse("2022-11-28");
  
        return $toDate->diffInYears($fromDate);  
    }
}

 

Example 4: Count the Days Between today's Date

In this example, we will count the days between today's date and the given date using carbon.

<?php
  
namespace App\Http\Controllers;
  
use Illuminate\Http\Request;
use Carbon\Carbon;
  
class DateController extends Controller
{
    public function index(Request $request)
    {
        $date = Carbon::parse("2021-11-28");

        return today()->diffInDays($date);  
    }
}

 


You might also like:

Recommended Post
Featured Post
Laravel 8 Eloquent whereHas Condition
Laravel 8 Eloquent whereHas Co...

In this example we will see laravel 8 eloquent whereHas() condition. you will learn about wherehas() condition in l...

Read More

Oct-06-2021

How To Check Email Already Exist Or Not In Laravel
How To Check Email Already Exi...

In this article, we will show how to check whether the email already exists or not in laravel. Also, we will check...

Read More

Aug-07-2020

Laravel 9 One To One Relationship Example
Laravel 9 One To One Relations...

  In this article, we will see laravel 9 one to one relationship example. Also, you can use one to one re...

Read More

Apr-01-2022

How To Get Last Record In Laravel 8
How To Get Last Record In Lara...

In this example, we will see how to get the last record in laravel 8. You can simply get the last record using laravel 8...

Read More

Jan-26-2022