- Joined
- Aug 17, 2011
- Messages
- 1
- Reaction score
- 0
Hi all,
I am having a bit of a problem with a query I am working on to display only the current week of records.
I am using BETWEEN Date()-DatePart("w",Date())+2 AND Date()
to filter records from the Monday of this week to the current day and my results are returning the 15th, 16th and 17th of this week like I want but also the 15th, 16th and 17th of every other month and year in my database.
Any ideas?
Thanks in advance
I am having a bit of a problem with a query I am working on to display only the current week of records.
I am using BETWEEN Date()-DatePart("w",Date())+2 AND Date()
to filter records from the Monday of this week to the current day and my results are returning the 15th, 16th and 17th of this week like I want but also the 15th, 16th and 17th of every other month and year in my database.
Any ideas?
Thanks in advance