/**
* @author Francis V.G.
* Policy term expiration calculator
* Business rules dictate that the expiration of a fixed-term warranty policy
* is calculated by multiplying 365 by the term, hence coverage than spans
* leap-years will have a few days difference between start and expiration dates.
*/
DECLARE @YearDays INT = 365;
DECLARE @TermInYears INT = 10;
DECLARE @Term INT = (@YearDays * @TermInYears);
SELECT
[Current] = DATEADD(DAY, @Term, '6/16/2015')
, [Correct] = DATEADD(DAY, @Term, '6/12/2015');