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
Generate Dynamic Sitemap in Laravel
Generate Dynamic Sitemap in La...

Here we will see how to generate dynamic sitemap in laravel. As we know sitemap is very important part of seo, sitemap i...

Read More

Jul-05-2021

How To Create Web Notifications In Laravel 9 Using Pusher
How To Create Web Notification...

In this article, we will see how to create web notifications in laravel 9 using pusher. Here, we will learn how to...

Read More

Feb-03-2023

Laravel Unique Validation on Update
Laravel Unique Validation on U...

Today in this post we will see laravel unique validation on update. unique validation rule in laravel is used when...

Read More

Sep-03-2021

How To Disable Past Date In jQuery Datepicker
How To Disable Past Date In jQ...

In this tutorial, we will see how to disable past dates in jquery datepicker. In the date picker, today's date...

Read More

Jun-18-2022