CODE EXAMPLE FOR SQL

dateadd in sql

SELECT DATEADD(year, 1, '2017/08/25') AS DateAdd;
--result
2018-08-25 00:00:00.000

SELECT DATEADD(year, -1, '2017/08/25') AS DateAdd;
--result
2016-08-25 00:00:00.000