Date problem

[raybetts]

I have a table with an ID, a qty, and a date (datetime) in sql 7.&nbsp;&nbsp;I want to query the database and retrieve all recs grouped by a given month. So rather than saying give me all recs = xx/xx/xxxx, I want to say give me all recs = 10 (or oct).&nbsp;&nbsp;Is this possible and if so how.<br><br>Cheers,<br><br>Ray.

 

[DarkMan]

Try this:<br><br><FONT FACE=monospace>select ID, qty, date<br>from MyTable<br>where DatePart(month,Date)=10</font><br><br>You probably want to go by month and year, so you may want to try:<br><br><FONT FACE=monospace>select ID, qty, date<br>from MyTable<br>where DatePart(month,Date)=10 and DatePart(year,Date)=1999</font><br><br>Let me know if this works.....

 

[raybetts]

Thanks Darkman it works like a dream.