Laravel search for records 7 days old only

Question

i am trying to pull records that are 7 days old only , not older or earlier. But its not working, i'm using Carbon.

->where(DB::raw('date(AppDate)'), Carbon::now()->subDays(7))

Answer 1

You can use whereDate for that :

->whereDate('created_at', Carbon::now()->subDays(7))
->get();

In the documentation :

The whereDate method may be used to compare a column's value against a date

PS : Since Laravel 5.3