... WHERE DBDate BETWEEN DateAdd("w",-2, [DateParam]) AND DateAdd("w", 2, [DateParam])
DBDate is the column you want to check and DateParam is the parameter date you wish to use. The DateAdd function adds the number of weeks ("w") specified in the second parameter (2) to the third parameter (DateParam). By using negative values (-2) you can 'subtract' weeks.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.