get only trashed older then number of days

Anyone know why this is not working?

Flight::onlyTrashed()->whereDate('deleted_at', '>=', now()->subDays(5)->toDateTimeString())->get();

It returns all the trashed... but I want only the trashed older then 5 days. How can I do that?

Best Answer

Level 20

Your comparision operator is wrong flip it .

Flight::onlyTrashed()
    ->where('deleted_at', '<=', now()->subDays(5))
    ->get();

2 likes

Level 5

@Shivamyadav yup, I don't know what I was thinking...it seems that I need to go to sleep :))

1 like

Level 20

@calin.ionut If you find my solution correct then mark the thread as solved by adding best answer.

Please or to participate in this conversation.