Date of 1st day of last, this, next month

from the Artful Common Queries page

Date of first day of previous month: 
concat(left(curdate() - interval 1 month, 8), '-01')
Date of first day of this month: 
concat(left(curdate(), 8), '-01')
Date of first day of next month: 
concat(left(curdate() + interval 1 month, 8), '-01')

Last updated 29 Mar 2024