Answered
SQL (Mysql) for recordset including only records less than 2 year old
Hi Folk,
I am trying to select records where the date field is less than 2 years from todays date.
Something like this:
_______________________________________________
SELECT *
FROM notes
WHERE userid = '$userid' AND date > ( NOW() -2 years)
_______________________________________________
Does anyone know how to write that in sql so it works?
Cheers
Dave