Level 51
$fiveDaysAgoDate = now()->addDays(-5);
$users = User::whereDate('expire_date', '=', $fiveDaysAgoDate->format('Y-m-d'))->get()
1 like
May 28, 2022
4
Level 3
Get users five days to expires date
I have a table with users and expires_date table, how do I write an Eloquent query to filter from the database and only pick users who have five(5) days more to the expiration date, by comparing the current date and expires date?
Level 3
@MohamedTammam Thanks
Level 122
$users = User::whereDate('expire_date', now()->addDays(5))->get();
Level 3
@Snapey Thanks for always coming to my rescue
Please or to participate in this conversation.