I am trying to extract objects from Model "Users" whose created_at date has been more than 30 days from today.
Carbon::now() ==> I want as ==> Carbon::now() - 30days
$users = Users::where('status_id', 'active')
->where( 'created_at', '<', Carbon::now())
->get();
How can this be achieved ?
Use subDays() method:
$users = Users::where('status_id', 'active')
->where( 'created_at', '>', Carbon::now()->subDays(30))
->get();
more means later here. Also Carbon::now() ==> I want as ==> Carbon::now() - 30days pretty much explains what OP wants.From Laravel 5.6 you can use whereDate:
$users = Users::where('status_id', 'active')
->whereDate( 'created_at', '>', now()->subDays(30))
->get();
You also have whereMonth / whereDay / whereYear / whereTime
You can always use strtotime to minus the number of days from the current date:
$users = Users::where('status_id', 'active')
->where( 'created_at', '>', date('Y-m-d', strtotime("-30 days"))
->get();
date('Y-m-d 00:00:00', strtotime("-30 days") to be more tidyAs with strtotime or DateTime, any (relative) date expressions can also be used with carbon::parse.
$users = Users::where('status_id', 'active')
->where( 'created_at', '>', Carbon::parse('Now -30 days'))
->get();
Alternatively for 'Now -30 Days', expressions '-30days' or '-720 hours' are also possible.
'Now -30 Days' takes into account the current time. If you need a time 00:00, use 'Today -30 Days'.
you can use carbon methods like subDays or subMonth methods
$object = User::whereActive()
->where( 'created_at', '<', now()->subDays($subDays))
->get();
