Delete all entries less than todays current date

Here is my code

DB::table('events')->where('eventDate','<=','DATE(CURDATE())')->get();

It is deleting everything even events I have set up with a future date

Please help?

Best Answer

Level 3

Try this

 $currentDate = Carbon\Carbon::now();

DB::table('events')->where('eventDate','<=',$currentDate)->get();

Level 7

Thank you!

Please or to participate in this conversation.