select * from event where d_date >= " + (DateTime.Now.Year-2).ToString("yyyy/MM/dd") + " order by (d_date) desc
select * from event where d_date >= DATE_SUB(NOW(), INTERVAL 2 YEAR) order by (d_date) desc
SELECT * FROM event WHERE d_date >= DATE_SUB(d_date, INTERVAL 2 YEARS) ORDER BY d_date DESC
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)