Level 1
my date field in datebase is in 2015-9-30/ Year-month-day format
Sep 24, 2015
3
Level 1
How to auto update a field in the table when current date is more than a specific date in the table.
I am doing a project where my website showcase event information and the date duration like example 5sep to 8sep. However i want to auto update a field in my event table which set Active to inactive, when current date already exceed 8sep. How do i define date as num value so i can state when current date > event date, then i auto update the active field in my table.
Level 88
You can always do something like this
$events = Events::where('created_at', '>=', new Carbon()->today)->get();
You can even us whereBetween
$startDate = Carbon::create(2015, 9, 5, 0, 0, 0);
$endDate = Carbon::create(2015, 9, 8, 0, 0, 0);
$events = Events::whereBetween('created_at', [$startDate, $endDate])->get();
Level 1
ty will try it
Please or to participate in this conversation.