Here is an example of doing date addition/subtraction in a MySQL query.

SELECT * FROM Table WHERE DateField > (now() - INTERVAL 1 year)