Get Previous StartDate And EndDate

Get PreviousStartDateAndEndDate.sql

DECLARE @CurrentDate DATE = GETDATE();
DECLARE @FirstDayOfPreviousMonth DATE;
DECLARE @LastDayOfPreviousMonth DATE;

-- Calculate the first day of the previous month
SET @FirstDayOfPreviousMonth = DATEADD(MONTH, DATEDIFF(MONTH, 0, @CurrentDate) - 1, 0);

-- Calculate the last day of the previous month
SET @LastDayOfPreviousMonth = EOMONTH(DATEADD(MONTH, -1, @CurrentDate));

-- Select the results
SELECT @FirstDayOfPreviousMonth AS StartDate, @LastDayOfPreviousMonth AS EndDate;