SQL Date Problem

[andrewharris]

I am only just starting to use SQL as was using Access.

I need to obtain records from a a few days previous (day varies) and would use
Select * from Members
Where Subscribed = Date() -4

Which would give me all new records from 4 days ago.

I need to do this is SQL but as its stores datetime i have a problem.

I have got as far as
SELECT MemberID, convert(varchar,Subscribed,103) as Subscribed
FROM dbo.Members

Which gives me just the date but not the records from 4 days etc

But dont know how to do the GetDate() version of date()