Laravel Get Today Yesterday this & last Month this & last Year
In today's tutorial, we will see practical examples of how to get records that belong to today yesterday, this & last month, and this & last year in Laravel.
Get data of today in laravel
You can use this Laravel eloquent query to fetch today's records:
Order::whereDay('created_at', Carbon::today())
->latest()->get();
Get data of yesterday in laravel
You can use this Laravel eloquent query to fetch yesterday's records:
Order::whereDay('created_at', Carbon::yesterday())
->latest()->get();
Get data of this month in laravel
You can use this Laravel eloquent query to fetch the current month's records:
Order::whereMonth('created_at', Carbon::now()->month)
->latest()->get();
Get data of last month in laravel
You can use this Laravel eloquent query to fetch the last month's records:
Order::whereMonth('created_at', Carbon::now()->subMonth()->month)
->latest()->get();
Get data of this & last year in laravel
You can use this Laravel eloquent queries to fetch the current year's and last year's records:
//this year
Order::whereYear('created_at', Carbon::now()->year)
->latest()->get();
//last year
Order::whereYear('created_at', Carbon::now()->subYear()->year)
->latest()->get();