Need to Select Year Only

[heathL]

I want to write a select statement to find dates with 2002 only. If I use the entire date format for a single date like 1/1/2002 (see the code below), it works but I want to find all 2002 dates not just one.


sql = "SELECT * FROM tblNewsStories Where archived='Yes' AND Date = '1/1/2002' ORDER BY date DESC"

 

[CasperTFG]

sql = "SELECT * FROM tblNewsStories Where archived='Yes' AND Date > '12/31/2001' ORDER BY date DESC"

Craig

"I feel sorry for people who don't drink. When they wake up in the morning, that's as good as they're going to feel all day."
~Frank Sinatra

 

[chmohan]

sql = &quot;SELECT * FROM tblNewsStories Where archived='Yes' AND Date > '31/12/2001' AND Date < '1/1/2003' ORDER BY date DESC&quot;

 

[CasperTFG]

Good catch chmohan... I missed the 2000 only part of the question.

Craig

&quot;I feel sorry for people who don't drink. When they wake up in the morning, that's as good as they're going to feel all day.&quot;
~Frank Sinatra

 

[blwill]

sql = &quot;SELECT * FROM tblNewsStories Where archived='Yes' AND DATEPART(yyyy, Date) = '2002' ORDER BY date DESC&quot;

 

[heathL]

Thanks. It works!