How to query between two dates using Laravel and Eloquent?

by

The whereBetween method verifies that a column’s value is between
two values.

$from = date('2018-01-01');
$to = date('2018-05-02');

Reservation::whereBetween('reservation_from', [$from, $to])->get();

In some cases you need to add date range dynamically. Based on @Anovative‘s comment you can do this:

Reservation::all()->filter(function($item) {
  if (Carbon::now()->between($item->from, $item->to)) {
    return $item;
  }
});

If you would like to add more condition then you can use orWhereBetween. If you would like to exclude a date interval then you can use whereNotBetween .

Reservation::whereBetween('reservation_from', [$from1, $to1])
  ->orWhereBetween('reservation_to', [$from2, $to2])
  ->whereNotBetween('reservation_to', [$from3, $to3])
  ->get();

Other useful where clauses: whereIn, whereNotIn, whereNull, whereNotNull, whereDate, whereMonth, whereDay, whereYear, whereTime, whereColumn , whereExists, whereRaw.

Laravel docs about Where Clauses.

More Related Contents:

  1. Laravel 5.1, Return response to user, then excute some code [closed]
  2. Laravel combined OR AND Solution
  3. Laravel 5 – How to access image uploaded in storage within View?
  4. Get Specific Columns Using “With()” Function in Laravel Eloquent
  5. How to pass data to all views in Laravel 5?
  6. Laravel Check If Related Model Exists
  7. How can I convert many statement mysql to laravel eloquent?
  8. Laravel: How to Get Current Route Name? (v5 … v7)
  9. Laravel Model with Two Primary Keys update [duplicate]
  10. Laravel: How can I change the default Auth Password field name?
  11. No Application Encryption Key Has Been Specified
  12. Access denied for user ‘homestead’@’localhost’ (using password: YES)
  13. How to change / Custom password field name for Laravel 4 and Laravel 5 user authentication [duplicate]
  14. How to execute Stored Procedure from Laravel
  15. How to fix the “Base table or view not found: 1146” error when running ‘php artisan migrate’ command?
  16. How to redirect back to form with input – Laravel 5
  17. Laravel Socialite: InvalidStateException
  18. Laravel 5.4 on PHP 7.0: PDO Exception – Could not find driver (MySQL)
  19. Prevent Browser’s Back Button Login After Logout in Laravel 5
  20. Laravel – How to get current user in AppServiceProvider
  21. How to set the default value of an attribute on a Laravel model [duplicate]
  22. Difference between Eloquent\Model::get() and all()
  23. required_if Laravel 5 validation
  24. Login only if user is active using Laravel
  25. laravel 5.3 new Auth::routes()
  26. Laravel changing timezone not reflecting the correct time
  27. How to remove /public/ from a Laravel URL
  28. Error 405 (Method Not Allowed) Laravel 5
  29. Unit Test Laravel’s FormRequest
  30. find in set in laravel ? example

Leave a Comment