How to query between two dates using Laravel and Eloquent

Question

I m trying to create a report page that shows reports from a specific date to a specific date  Here s my current code    now   date  Y-m-d     reservations   Reservation  where  reservation from    now - gt get      What this does in plain SQL is select   from table where reservation from    now    I have this query here but I don t know how to convert it to eloquent query   SELECT   FROM table WHERE reservation from BETWEEN   from  AND   to   How can I convert the code above to eloquent query  Thank you in advance

User · Answer

The following should work    now   date  Y-m-d     reservations   Reservation  where  reservation from     gt      now                             - gt where  reservation from     lt      to                             - gt get

User · Answer

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  - gt get        In some cases you need to add date range dynamically  Based on  Anovative s comment you can do this   Reservation  all  - gt filter function  item      if  Carbon  now- gt between  item- gt from   item- gt 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     - gt orWhereBetween  reservation to     from2   to2     - gt whereNotBetween  reservation to     from3   to3     - gt get        Other useful where clauses  whereIn  whereNotIn  whereNull  whereNotNull  whereDate  whereMonth  whereDay  whereYear  whereTime  whereColumn  whereExists  whereRaw   Laravel docs about Where Clauses

User · Answer

Try this       Since you are fetching based on a single column value you can simplify your query likewise    reservations   Reservation  whereBetween  reservation from   array  from   to  - gt get      Retrieve based on condition  laravel docs  Hope this helped

User · Answer

If you need to have in when a datetime field should be like this   return  this- gt getModel  - gt whereBetween  created at     dateStart   00 00 00   dateEnd   23 59 59   - gt get

User · Answer

Another option if your field is datetime instead of date  although it works for both cases     fromDate    2016-10-01    toDate      2016-10-31     reservations   Reservation  whereRaw      reservation from  gt     AND reservation from  lt             fromDate   00 00 00    toDate   23 59 59    - gt get

User · Answer

If you want to check if current date exist in between two dates in db    here the query will get the application list if employe s application from and to date is exist in todays date    list    new LeaveApplication                - gt whereDate  from    lt      today              - gt whereDate  to    gt      today              - gt get

User · Answer

And I have created the model scope  More about scopes    https   laravel com docs 5 8 eloquent query-scopes https   medium com  janaksan  using-scope-with-laravel-7c80dd6a2c3d   Code                 Scope a query to only include the last n days records                param   Illuminate Database Eloquent Builder  query         return  Illuminate Database Eloquent Builder             public function scopeWhereDateBetween  query  fieldName  fromDate  todate                return  query- gt whereDate  fieldName   gt     fromDate - gt whereDate  fieldName   lt     todate           And in the controller  add the Carbon Library to top   use Carbon Carbon    OR  use Illuminate Support Carbon    To get the last 10 days record from now    lastTenDaysRecord   ModelName  whereDateBetween  created at   new Carbon - gt subDays 10 - gt toDateString    new Carbon - gt now  - gt toDateString    - gt get      To get the last 30 days record from now    lastTenDaysRecord   ModelName  whereDateBetween  created at   new Carbon - gt subDays 30 - gt toDateString    new Carbon - gt now  - gt toDateString    - gt get

User · Answer

I know this might be an old question but I just found myself in a situation where I had to implement this feature in a Laravel 5 7 app  Below is what worked from me     articles   Articles  where  created at    gt    Carbon  now  - gt subMonths 3  - gt get      You will also need to use Carbon  use Carbon Carbon

[php] How to query between two dates using Laravel and Eloquent?

Examples related to php

Examples related to laravel

Examples related to laravel-5

Examples related to orm