如何获取当周星期一到星期六的数据 [英] how to get data of current week monday to saturday

问题描述

我尝试下面的代码，但我想显示从星期一到星期六的数据意味着如果用户在星期三登录它显示星期一到星期六的数据只是星期三到星期三

i tried below code but i want to display data from monday to saturday means if user login on wednesday it show data from monday to saturday only not wednesday to tuesday

OR (@Range='This Week' AND CAST(S.ScheduleDateTime AS DATE) >= DATEADD(week, DATEDIFF(day, 0, getdate())/7, 0)  AND CAST(S.ScheduleDateTime AS DATE) <= DATEADD(week, DATEDIFF(day, 0, getdate())/7, 5))

推荐答案

SELECT DATEADD(ww, DATEDIFF(ww,0,GETDATE()), 0) AS Monday, DATEADD(ww, DATEDIFF(ww,0,GETDATE()), 5) as Saturday

这篇关于如何获取当周星期一到星期六的数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！