//The following code fetches data for yesterday and tomorrow as well As I only need to fetch users that are registered today $between = array(date('Y-m-d', strtotime('-1 day')), date('Y-m-d',strtotime('+1 day'))); $record = \App\User::whereBetween('created_at', $between )->get();