Some SQL fun from Dynamics University: Get First and Last Date of Previous Month
Get First and Last Date of Previous Month | Dynamics University
SQL & DataDevelopment & Integration
Archived post from 2014. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.