Should be more like the following
date_sub(now() - 30 day)
or
date_sub(curdate() - 1 MONTH)
Check with mysql documentation on exact syntax , but this should point you in the right direction.
Sign in to participate in this thread!
The Laravel portal for problem solving, knowledge sharing and community building.
The community