Query builder - filter by date (+ x days > today)

? :)

It should be pretty straight forward with https://github.com/briannesbitt/Carbon

Carbon::now()->addDays(5)->toDateTimeString()

Will give you a date 5 days into the future, formatted as a datetime string just as it appears in your database. Then you can use something like query scopes (http://laravel.com/docs/5.1/eloquent#query-scopes) to make your query reusable and readable.

Thanks but not what I'm looking for @colourmill .

What I am trying to do is retrieve records (with Eloquent or query builder) filtering by (date attribute + days attribute from related record) > Carbon::now().

@GastonUy Oh I see now… sorry, I misread it. You'll most likely have to work with a stored function for that (http://www.mysqltutorial.org/mysql-stored-function/). From by brief experiences with them, they're not extremely pleasant to work with, but your example seems simple enough that it shouldn't be too much of a hassle.

Alternatively, you could do an optimistic selection where you select the flights that could be relevant, and then filter the results through the handy collection methods.

You'll end up with something like this:

$flights = Flight::where('has_landed', '=', 1)->get(); // You'll want to add a date range or something to lower the returned results
$flights->filter(function ($flight) {
    return $flight->daysAfterFlightLanded + $flight->landed_on > now;
});

Thanks again @colourmill . This gives me an idea about how to deal with the problem.