筛选日期为上一季度的日期

// 获取当前日期
var currentDate = new Date();

// 获取上一季度的起始日期
var startQuarterDate = new Date(currentDate.getFullYear(), currentDate.getMonth() - 3, 1);

// 获取上一季度的结束日期
var endQuarterDate = new Date(currentDate.getFullYear(), currentDate.getMonth(), 0);

// 格式化日期为字符串
var startDateString = startQuarterDate.toISOString().split('T')[0];
var endDateString = endQuarterDate.toISOString().split('T')[0];

// 输出结果
console.log("上一季度的起始日期：" + startDateString);
console.log("上一季度的结束日期：" + endDateString);

-- 获取当前日期
DECLARE @currentDate DATE = GETDATE();

-- 获取上一季度的起始日期
DECLARE @startQuarterDate DATE = DATEADD(QUARTER, -1, DATEADD(QUARTER, DATEDIFF(QUARTER, 0, @currentDate), 0));

-- 获取上一季度的结束日期
DECLARE @endQuarterDate DATE = DATEADD(DAY, -1, DATEADD(QUARTER, DATEDIFF(QUARTER, 0, @currentDate), 0));

-- 输出结果
SELECT '上一季度的起始日期：' + CONVERT(VARCHAR, @startQuarterDate, 23) AS StartDate,
       '上一季度的结束日期：' + CONVERT(VARCHAR, @endQuarterDate, 23) AS EndDate;