Need help with a complicated SQL statement

  • Thread starter Thread starter Mark Hackenberg
  • Start date Start date
M

Mark Hackenberg

Hi,

I have an Access 2000 database and one of the columns is a
time/date stamp when the date was entered. I want to be
able to run a query of all records within a week of the
current week i.e. if today is Dec. 23 I want to be able to
look up all records where time/date stamp column is Dec.
16-Dec 30.

Does anyone know the appropriate SQL statement for this?

Thanks,

Mark
 
....
WHERE DateStamp BETWEEN DateAdd("d", -7, Date())
AND DateAdd("d", 7, Date())
 
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

Help write SQL statement to retrieve data 2
complicated query 5
Week starts on Friday 2
Need help with SQL Statement in MS Access 2003 Chart 11
Calculate End Date Using Start Date and No. of Days excluding specific days. 0
Display all latest Entries 2
query for attendance 1
Need help with SQL statement 4

Back
Top