Laravel: Filter out users created more than three months ago

Question

In my Laravel application, I want to get all user records where the "created_at" timestamp is three months earlier than the current date. Is this possible using the Eloquent query builder?

Answer 1

First, you can use Carbon to get the date 3 months ago.

$date = Carbon::now()->subMonths(3)->format('Y-m-d');

Then we need all the records before that. So, the query should be -

$users = User::where('created_at', '<=', $date)->get();