In SQL - 2000 For a view I need all the transactions in the past 7 Day 1

[shivalisv]

In SQL Server - 2000 Under Query Analyzer For a view I need all the transactions in the past 7 Days excluding the current Day. I have a field Transaction Date Field in the Database. How Could I extract only those Transactions ?

 

[vidru]

SELECT * FROM Transactions
WHERE TransactionDate >=
DATEADD(DAY, -7, CONVERT(SMALLDATETIME, CONVERT(CHAR(10), GETDATE(), 101)))
AND TransactionDate < CONVERT(SMALLDATETIME, CONVERT(CHAR(10), GETDATE(), 101))

-dave