Finding days between two dates in laravel [duplicate]

Question

I have to dates. Now, I need to find the difference between these two for further calculations.

I tried different ways but I am not able to fix the issues. Can anyone tell me the best way to do it.

My code is:

public function leaveRequest(request $request)
{
    $fdate=$request->Fdate;
    $tdate=$request->Tdate;

    $start = Carbon::parse($fdate)->format('Y/m/d');
    $end =  Carbon::parse($tdate)->format('Y/m/d');

    $days = $end->diffInDays($start);
    /*$days=date_diff($end,$start);*/
    echo $days;
    exit;

    $user = User::findOrFail(Auth::user()->id);
    Mail::send('pages.leave', ['user' => $request,'userId'=>$user], function ($m) use ($request) {
        $m->to($request->Email)->subject('Leave Request!');
    });

    DB::table('leaves')->insert(
        ['user' => Auth::user()->id, 'request_date' => Carbon::now(),'start' => $start,'end' => $end,'permissions' => "Pending",'leave_status' => "Active"]
    );

    return redirect()->back()->with('message','Your request has sent');
}

If I can get the days then I can insert it into the leaves table.

The actual answer to this question is to do just $start = Carbon::parse($fdate); and $end = Carbon::parse($tdate); By using the Carbon::format() function you got a string, so you would have received an error like "Call to member function diffInDays() on non-object" — miken32
– miken32, Commented Dec 5, 2022 at 23:14

Ryan M · Accepted Answer · 2022-07-07 03:12:03Z

52

You don't need Carbon, you can do that using simple PHP. Best is to use PHP OOP way. Like this:

$fdate = $request->Fdate;
$tdate = $request->Tdate;
$datetime1 = new DateTime($fdate);
$datetime2 = new DateTime($tdate);
$interval = $datetime1->diff($datetime2);
$days = $interval->format('%a');//now do whatever you like with $days

PS : DateTime is not a function, it's a class, so don't forget to add : use DateTime; at top of your controller so that it can reference to right root class, or use \DateTime() instead when making its instance.

edited Jul 7, 2022 at 3:12

Ryan M♦

20.6k35 gold badges75 silver badges85 bronze badges

answered Jan 3, 2017 at 13:19

Abhay Maurya

12.3k9 gold badges50 silver badges67 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Kiran Rai Chamling Over a year ago

I am writing this code in a Controller. This code throws an error : Class 'App\Http\Controllers\Admin\DateTime' not found. DateTime works with php.

Abhay Maurya Over a year ago

Add use DateTime; at the top of the controller and try again.

Kiran Rai Chamling Over a year ago

Tried that and it worked!. Before, I was using DateTime of Carbon. It didn't helped me. Thanks

Abhay Maurya Over a year ago

@Kiran Rai Chamling, Please mark the answer as accepted if it helped you to close this thread. Thanks

ibnɘꟻ Over a year ago

Just in case something went wrong, you can add try { } catch (\Exception $e){} on your DateTime code. Because DateTime class would throw Exception when error occured. Thanks to PHPStorm for reminds me.

|

Stephen Rauch · Accepted Answer · 2017-09-02 05:47:47Z

22

$to = \Carbon\Carbon::createFromFormat('Y-m-d H:s:i', '2015-5-5 3:30:34');
$from = \Carbon\Carbon::createFromFormat('Y-m-d H:s:i', '2015-5-6 9:30:34');

$diff_in_days = $to->diffInDays($from);

print_r($diff_in_days); // Output: 1

edited Sep 2, 2017 at 5:47

Stephen Rauch♦

50.1k32 gold badges118 silver badges143 bronze badges

answered Sep 2, 2017 at 5:23

paddy sable

2212 silver badges2 bronze badges

Comments

Zafar Shah Faizi · Accepted Answer · 2021-12-16 11:53:38Z

9

Why not use Carbon helper to get the exact date

$to = \Carbon\Carbon::parse($request->to);
$from = \Carbon\Carbon::parse($request->from);

        $years = $to->diffInYears($from);
        $months = $to->diffInMonths($from);
        $weeks = $to->diffInWeeks($from);
        $days = $to->diffInDays($from);
        $hours = $to->diffInHours($from);
        $minutes = $to->diffInMinutes($from);
        $seconds = $to->diffInSeconds($from);

edited Dec 16, 2021 at 11:53

Zafar Shah Faizi

5443 silver badges18 bronze badges

answered Nov 17, 2021 at 5:37

Hadayat Niazi

2,5664 gold badges24 silver badges35 bronze badges

Comments

bhucho · Accepted Answer · 2020-07-16 06:18:24Z

3

Anyone using PHP version < php 5.3, they can do using timestamps, Like this:

$fdate = $request->Fdate;
$tdate = $request->Tdate;
$datetime1 = strtotime($fdate); // convert to timestamps
$datetime2 = strtotime($tdate); // convert to timestamps
$days = (int)(($datetime2 - $datetime1)/86400); // will give the difference in days , 86400 is the timestamp difference of a day

answered Jul 16, 2020 at 6:18

bhucho

3,4303 gold badges19 silver badges36 bronze badges

Comments

Salman Zafar · Accepted Answer · 2020-01-28 12:26:45Z

2

$from=Carbon::now()->subDays(5)->toDateString();

$current=Carbon::now()->toDateString();

$peoples= People::whereBetween('joiningdate',array($diff,$current))->get();

edited Jan 28, 2020 at 12:26

Salman Zafar

4,0655 gold badges23 silver badges44 bronze badges

answered Apr 4, 2019 at 13:59

rahul modi

314 bronze badges

1 Comment

Bob Dalgleish Over a year ago

You need to provide an explanation why your answer addresses the original question. See stackoverflow.com/help/how-to-answer

AhsanRao · Accepted Answer · 2022-03-10 05:42:28Z

0

// get from and throung date
$from_date = Carbon::parse(date('Y-m-d', strtotime('2022-03-10'))); 
$through_date = Carbon::parse(date('Y-m-d', strtotime('2022-03-12'))); 
    
// get total number of minutes between from and throung date
$shift_difference = $from_date->diffInDays($through_date);

// will output $shift_difference = 2

answered Mar 10, 2022 at 5:42

AhsanRao

135 bronze badges

Comments

Labhansh Satpute · Accepted Answer · 2022-11-13 06:11:35Z

0

I used this method and it is properly working for me. If you want to verify date of birth with the requested age then use it.

$date_of_birth = Carbon::parse($request->input('student_dob'));
$current_date = Carbon::now();

if ($current_date->diffInYears($date_of_birth) != $request->input('student_age')) {
    return response(['status' => false, 'error' => [
        'student_dob' => ['date of birth not matched with age']
    ]], 500);
}

answered Nov 13, 2022 at 6:11

Labhansh Satpute

4695 silver badges8 bronze badges

Collectives™ on Stack Overflow

Finding days between two dates in laravel [duplicate]

7 Answers 7

6 Comments

Comments

Comments

Comments

1 Comment

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

7 Answers 7

6 Comments

Comments

Comments

Comments

1 Comment

Comments

Comments

Linked

Related