How to found settlement amount between two dates in laravel project

Question

How to calculate the amount between 2 dates. For example Consider if in month January 2021 I need to get the amount between From Date: 1st Jan 2021 and To Date : `15 Jan 2021. The calculation should be = Total Amount - (Amount from 16 Jan to 31 Jan)

Hope for a guidance to solve this :)

I assume that you will calculate amount from the database, then you should use whereBetween stackoverflow.com/questions/33361628/… — Anurat Chapanond
– Anurat Chapanond, Commented Dec 30, 2020 at 4:22

Nino Giovanny · Accepted Answer · 2020-12-30 04:56:22Z

0

Use whereBetween... Try:

$date1 = date('2021-01-01');
$date2 = date('2021-01-15');
    
Your_Model::whereBetween('date_col', [$date1, $date2])
    ->select( DB::raw('SUM(your_col) as amount'))
    ->get();

answered Dec 30, 2020 at 4:56

Nino Giovanny

1214 bronze badges

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

Comments

Hanif Mia Fabel · Accepted Answer · 2020-12-30 06:24:41Z

0

$date1 = 1st Jan 2021 //formate upto you, standard format 2021-01-01
$date2 = 15 Jan 2021 //formate upto you, standard format 2021-01-15

$total_amount = $date1->diff($date2);

Or follow this,

Finding days between two dates in laravel

I hope it will be work!

edited Dec 30, 2020 at 6:24

answered Dec 30, 2020 at 6:16

Hanif Mia Fabel

191 silver badge7 bronze badges

Collectives™ on Stack Overflow

How to found settlement amount between two dates in laravel project

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related