Date

  • Thread starter Thread starter Gilbo
  • Start date Start date
G

Gilbo

How do I write a query that when someone serches for a date in my date field
it will return dates four days before and four day after, the date that was
inputted.
 
Between InputtedDate - 4 And InputtedDate + 4

or

Between DateAdd("d", -4, InputtedDate) And DateAdd("d", 4, InputtedDate)

hth
 
Back
Top