Subtract days from the current date with Laravel Carbon.

Published: 12 February 2022

Category: php

Problem

I’m trying to retrieve items from Model “Users” that have been generated more than 30 days ago.

Carbon::now() ==> I’d like it to be as ==> 30 days – Carbon::now()

$users = Users::where('status_id', 'active')
               ->where( 'created_at', '<', Carbon::now())
               ->get();

What is the best way to accomplish this?

Asked by zeetit

Use subDays() method:

$users = Users::where('status_id', 'active')
           ->where( 'created_at', '>', Carbon::now()->subDays(30))
           ->get();

To subtract the amount of days from the current date, use strtotime:

$users = Users::where('status_id', 'active')
           ->where( 'created_at', '>', date('Y-m-d', strtotime("-30 days"))
           ->get();

You can use whereDate: since Laravel 5.6.

$users = Users::where('status_id', 'active')
       ->whereDate( 'created_at', '>', now()->subDays(30))
       ->get();

There’s also whereMonth/whereDay/whereYear/whereTime.

Answered by Joskfg