Date querie

F

Fred

I need to know how to build a querie that can search 3
days before and 3 days after todays date. It will be used
in a date column. Is there a way to do this? Thanks for
any help.
 
V

Van T. Dinh

SELECT *
FROM YourTable
WHERE DateField
Between DateAdd("d", -3, Date())
And DateAdd("d", 3, Date())
 
Top