https://koz.tv/start-of-month-from-date-in-ms-sql-opposite-to-eomonth-function/
Start of month from date in MS SQL (opposite to EOMONTH function)