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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel How to get the number of days an item was opened from the today's date. 14
Creating an update query that uses multiple parameters 2
Excel VBA to go to specific sheet & cell in the current workbook not working. 2
Duplicate a set of rows for each item (subdatasheet?) 0
Excel Excel Show Countdown Date 7
Access Property sheet data missing also syntax 0
Excel Vba to change displayed year automatically. 14
Excel Message box with days of month & date. 1

Back
Top