Q:

Laravel query for showing records starting soonest but not records where date has passed

I'm a little new so I only know the basics. I have a course table where it has the start_date of a course (timestamp) and  I would like to show the courses starting closes to the current date but not courses that have passed (e.g yesterdays courses).
I also need to not do this with a scope.
My model is App\Course. My current code is 
$course = Course::latest()->take(6)->get());

Could anyone help? Thanks!

A:

Try this:
$course = Course::where('start_date', '>', Carbon::now())->orderBy('start_date', 'desc')->take(6)->get());

It will work if you'll add start_date to a $dates variable.

