Laravel: select item where date is previous to today

Hi, imagine I have a model in my database wich has a filed "date", this file is a Carbon timestamp.

Now, I want to retrieve all instances of that model where date field has not yet come, that is, where the date field is prior to Carbon::now() timestamp.

Any suggestions?

manelgavalda

7 years ago

Best Answer

Level 50

You can use normal comparators to compare dates with eloquent:

Model::whereDate('date', '<', today())->get();

Docs: https://laravel.com/docs/5.7/queries#where-clauses

1 like

Please or to participate in this conversation.