Date

[netguy]

I have a field in by database called ACT_DATE. This is the date an item is scheduled to be completed. I want to create a query that when exec regardless of the day of the week it is, will look for any records that fall within that week.



Like for example:
SELECT Count(tbl_Activities.ACT_DATE) AS [This Week]
FROM tbl_Activities
WHERE tbl_Activities.ACT_DATE >= DATEADD(wk, DATEDIFF(wk,0,DATE()), 0) AND <= DATEADD(wk, DATEDIFF(wk,0,DATE()), 4);

[pbaldy]

This is marked as solved; if so, posting the solution could help others later.