SQL DATEPART/GETDATE Filtering

[Shrimpersfan]

Hi all.

I am trying to use the DATEPART function on GETDATE() in the WHERE clause. I need to only show the results if GETDATE's month is not in December or January.

Any ideas?

Cheers

[srochford]

select * from jobs where datepart(m,logdate)=12

gets you december only

select * from jobs where datepart(m,logdate)=12 or datepart(m,logdate)=1

gets you January and December.

Getting "not January and not December" is just a case of negating that -

select * from jobs where not(datepart(m,logdate)=12)  and not(datepart(m,logdate)=1)

although because we "know" something about months you can simplify it to:

select * from jobs where datepart(m,logdate) between 2 and 12