Date Range

[strom99]

WHERE
detail.rqst_del_date >= ''01/01/'' + datename(year,getdate()) and detail.rqst_del_date <= dateadd(month, 8, getdate())

I have the above in my where clause, but I need to make a change in order to go back 6 months from the first of this month, so I would include all records from July 1 2002 to 8 months from today. SQL Server 2000

Thanks much!!

 

[mwolf00]

SELECT * FROM myTable
WHERE rqst_del_date BETWEEN
dateAtt(m,cast(datePart(m, getDate()) + '/1/' + datePart(yyyy, getDate()) as smalldatetime),-6) AND dateAdd(m, getDate(),8) Get the Best Answers! faq333-2924
Happy 2003!
mikewolf@tst-us.com

 

[tlbroadbent]

Try this.

WHERE detail.rqst_del_date Between
Dateadd(m,-6,Dateadd(d,-day(getdate())+1,Getdate()))
And dateadd(m,8,getdate()) Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

If you want to get the best answer for your question read faq183-874.