Laravel - Sum values between two dates

Question

I need to sum values using Laravel db::table and get the result between two dates, example:

Date: 05/30/2016 Sold: 1 Date: 05/31/2016 Sold: 2

So result should be Sold: 3

This is a search result given by a filter by date, i have done something like this with no results:

DB::table('sales')
 ->where('date',$date_from)
 ->where('date',$date_to)
 ->selectRaw('sum(price)')
 ->selectRaw('id')
 ->groupBy('id')
 ->get();

D Coder · Accepted Answer · 2017-06-06 13:13:34Z

1

You Should use whereBetween(), Try this one

DB::table('sales')
->whereBetween('date', [$date_from, $date_to])
->selectRaw('sum(price)')
->selectRaw('id')
->groupBy('id')
->get();

answered Jun 6, 2017 at 13:13

D Coder

5724 silver badges16 bronze badges

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

Comments

Alexey Mezenin · Accepted Answer · 2017-06-06 13:13:01Z

1

Use < and > to filter results by a date:

->where('date', '>', $date_from)
->where('date', '<', $date_to)

Or use whereBetween():

->whereBetween('date', [$date_from, $date_to])

answered Jun 6, 2017 at 13:13

Alexey Mezenin

164k27 gold badges309 silver badges287 bronze badges

1 Comment

lucasvm1980 Over a year ago

Hello, i have tried this: $date_from = '2016-09-25 00:00:00.000000'; $date_to = '2016-09-26 00:00:00.000000'; ->where('date', '>', $date_from ) ->where('date', '<', $date_to ) And with Laravel im getting empty results, but when using common sql sentence on phpmyadmin im getting values.

Aboudeh87 · Accepted Answer · 2017-06-06 13:34:21Z

1

You should use whereBetween function, and I think you are using a wrong group by:

DB::table('sales')
        ->whereBetween('date', [$date_from, $date_to])
        ->groupBy('date')
        ->sum('price');

And if the date column's type is a `DATETIME, you should use:

->groupBy(DB::raw("DATE(date)"))

answered Jun 6, 2017 at 13:34

Aboudeh87

7175 silver badges17 bronze badges

Collectives™ on Stack Overflow

Laravel - Sum values between two dates

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related