get the beginning of last month based on today's date sql server code example
Example: sql server beginning of month
SELECT DATEADD(month, DATEDIFF(month, 0, @mydate), 0) AS StartOfMonth
SELECT DATEADD(month, DATEDIFF(month, 0, @mydate), 0) AS StartOfMonth