根据getdate拉取前一周

Question

我希望在获取日期的基础上计算上周的销售总额。我需要查看今天的日期，它是24周，并将前一周23周的所有销售相加。我希望基于getdate()动态地做这件事。

Answer 1

下面的查询将帮助您

DECLARE @CurrentDate datetime,
        @CurrentWeekFrom datetime,
        @LastWeekFrom datetime,
        @LastWeekEnd datetime

SET @CurrentDate = GetDate()
SET @CurrentWeekFrom = DateAdd(wk, DateDiff(wk, 0, @CurrentDate), 0)  
SET @LastWeekFrom = DateAdd(wk, -1, @CurrentWeekFrom)
SET @LastWeekEnd = DateAdd(dd, -1, @LastWeekFrom)

SELECT SUM(Sales) AS Sales FROM table1
               Where SalesDate Between  @LastWeekFrom And @LastWeekEnd