Date querie

  • Thread starter Thread starter Fred
  • Start date Start date
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.
 
SELECT *
FROM YourTable
WHERE DateField
Between DateAdd("d", -3, Date())
And DateAdd("d", 3, Date())
 
Back
Top