3 month Trailing Date 1

[dscoiho]

Using SQL Server 2000. I have two Fields that I trying to limit to:

TRADE_MONTH(int)
TRADE_YEAR(int)

What I am trying to do is get the previous 3 fullmonths. So today is March 2007 I need December 2006 to February 2007. Trying to keep from having to manually input the numbers to query my results.

Also if anyone has a dateserial also for a different query that would greatly appreciated too.

Field is
datetime: 2004-10-16 09:44:05.380


Thanks for any help or insight.

 

[AlexCuse]

Take a look at this:

select dateadd(month, datediff(month, 0, dateadd(month, -3, getdate())), 0)

So if that works, you could take everything

where datecol >= dateadd(month, datediff(month, 0, dateadd(month, -3, getdate())), 0)

Hope this helps,

Alex

Ignorance of certain subjects is a great part of wisdom