Try:
SELECT * FROM myTable WHERE myDate BETWEEN '2011-01-10' AND GETDATE()
This selects all dates between 10th Jan 2011 and today inclusive. If you need to exclude a date, you will need to code the WHERE clause differently:
SELECT * FROM myTable WHERE myDate > '2011-01-10' AND myDate <= GETDATE()