Get Records of Last 12 Months

[Mudassir]

Hi every one.
i want to write a query to get the records of last 12 months in sql like in
LINK
in its ARCHIVES section at side bar.

any kind of help will be greatly appreciated.

Regards
Mudassir

[Luuk]

SELECT * FROM YourTable WHERE Date Between GETDATE()-365 AND GETDATE();