I'm trying to run a few queries that will end up showing me data that has dates of today, 3 days from today, 5 days from today, and so on.
Right now my range code looks like this:
Code:WHERE dateends BETWEEN curdate() and curdate() + interval 3
Not sure that the code is right....when I use
It seems to be showing me everything, regardless of the date.Code:WHERE dateends <= CURDATE()
The dateends field is in DATE format.