Originally Posted by Fou-Lu
Your missing the interval on the until date. That is the same as using
datetxt >= CURDATE() - INTERVAL 2 WEEK. If you just want records from two weeks ago, but not from the current week, then you need to add the second interval condition.
Ok, I understand what you are saying but at the same time I don't. At least, when it comes to how to write the query for it, I'm not sure what I need to do and where I need to do it. Heading back to google for some help on this query.