The concept of "now" and date math varies from database to database, for example:
MySQL:
SELECT *
FROM Users
WHERE CreatedDate BETWEEN DATE_SUB(NOW(), INTERVAL 365 DAY) AND NOW();
Oracle:
SELECT *
FROM Users
WHERE CreatedDate BETWEEN SYSDATE - INTERVAL '365' DAY AND SYSDATE;
SQL Server:
SELECT *
FROM Users
WHERE CreatedDate BETWEEN DATEADD(DAY, -365, GETDATE()) AND GETDATE();
SQLite:
SELECT *
FROM Users
WHERE CreatedDate BETWEEN DATETIME('now', '-365 days') AND DATETIME('now');
MS Access:
SELECT *
FROM Users
WHERE CreatedDate BETWEEN DATEADD('d', -365, DATE()) AND DATE();
When asking questions in future please be clear about which technologies and versions you use
Edit: aye carumba - what's a post from aug 22 doing in my recent activity list? Was i looking at the recent activity list? PEBKAC