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
How to Format Number with 2 Decimal in PHP
How to Format Number with 2 De...

Hey there! If you've ever needed to work with numbers in PHP, you probably know how important it is to format them p...

Read More

Feb-26-2024

Laravel tips DB Models and Eloquent - Part 3
Laravel tips DB Models and Elo...

Welcome back to the third installment of our series on Laravel tips for database models and Eloquent. If you've been...

Read More

Oct-16-2023

How to Generate QR Code in Node.js
How to Generate QR Code in Nod...

In this example we will see how to generate QR Code in Node.js application. In this example we will use qrcode npm...

Read More

Sep-20-2021

Laravel 8 Create Custom Helper Function Example
Laravel 8 Create Custom Helper...

In this article, we will see laravel 8 create a custom helper function example. As we all know laravel provides man...

Read More

Oct-12-2020