Should be more like the following
date_sub(now() - 30 day)
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!
We'd like to thank these amazing companies for supporting us
The Laravel portal for problem solving, knowledge sharing and community building.