Recordset select by date

[davecheet]

I am trying to get a recordset to select all the dates in a list from a certain year (2010 or 2011). I think I am close but I can't quite get it to work. Can anyone pointout where I am going wrong?

"SELECT FROM dates WHERE coursecode LIKE 'MQA03' AND start_date <'2010-12-25' ORDER BY start_date";

Cheers

Dave

[derjaan · Accepted solution]

If I get your question right, you need something like this:

SELECT * FROM dates WHERE coursecode LIKE 'MQA03' AND start_date BETWEEN '2010-12-25' AND '2011-12-25'