不好意思:应该是
select * from table1
where datepart(dw,DateCol)>=datepart(dw,'2002-10-01')
and datepart(wk,DateCol)=datepart(wk,'2002-10-01')
应该填上你的输入日期,先格式化
select * from table1
where datepart(dw,DateCol)>=datepart(dw,'"& format(strdate,"yyyy-mm-dd") &"')
and datepart(wk,DateCol)=datepart(wk,'"& format(strdate,"yyyy-mm-dd") &"')