Answered : How to get records between two date in Laravel using eloquent

We can get records between two dates laravel5 with using Eloquent “whereBetween” method. Here sample function to get posts between two dates from database.

  public function getPosts(){
     $fromDate = date('Y-m-d' . ' 00:00:00', time());
     $toDate   = date('Y-m-d' . ' 22:00:40', time());
     $posts = POST:: where('user_id',$this->user_id)->where('status',1)->whereBetween('posted_on',[$fromDate, $toDate])->get();
     return $posts;
  }

Top Laravel Interview questions and answers for Fresher and Experienced

One thought to “Answered : How to get records between two date in Laravel using eloquent”

Leave a Reply

Your email address will not be published. Required fields are marked *