主题：[求助]DateDiff如何修改每周第一天

 是sql语句，还是代码DateDiff函数？

 可以用代码处理下

Dim d As Date = "2017-02-13"
Dim start As Date = "2017-01-23"
start = start.AddDays(1-start.DayOfWeek)
msgbox(start)
dim z as integer = Math.Ceiling(((d- start).TotalDays + 1) / 7)
msgbox(z)