SQL - determine if a date is one year old or more

Epicmanagement
Epicmanagement used Ask the Experts™
on
SQL 2000.  Microsoft SQL.

I need to figure out the SQL syntax to return only rows where the date (of a field) is at least one year old.

Here is my SQL:

Select * from Orders
Where OrderDate is at least one year old --- (But I need the correct SQL syntax)
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
ORDERDATE < GETDATE() - 365

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial