Skip to main content
davecheet
Inspiring
October 1, 2010
Answered

Recordset select by date

  • October 1, 2010
  • 1 reply
  • 383 views

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

This topic is closed to new replies. Start a new post to keep the conversation going.
Correct answer derjaan

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'

1 reply

derjaanCorrect answer
Inspiring
October 1, 2010

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'

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices