how to compare with date in where()

hello every one, iam trying to get the result where the date field is bigger than current date (( like in next days or weeks ))

i try following

ExamsSchedule::whereDate('exam_date', '>=', Carbon::now()->toDateString());

ExamsSchedule::where('exam_date', '>=', Carbon::now()->toDateString());

even i try to hard code it so i can see if there is a problem or something

ExamsSchedule::where('exam_date', '>=', '2016-10-28');

but same issue

anyone have something similar

btw my date field (exam_date) is in date type in db like (2016-10-23)

Level 51

Try with query builder

DB::table('ExamsSchedule')
                ->whereDate('exam_date', '>=', Carbon::now()->toDateString())
                ->get();

1 like

Best Answer

Level 15

@tomi hmmm this way its working but why not working with the where with model object, the issue now i cant use the other methods in relations =(

i found the issue >_< i didnt add the get() at the end

ExamsSchedule::where('exam_date', '>=', Carbon::now()->toDateString())->get();

thx

1 like

Level 1

Any idea how can we compare 2 diff dates like if created_date = #date1 or created_date=#date2

Level 5

$from = date('2018-01-01');

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

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

Please or to participate in this conversation.