Date Arithmetic generating a new date with the months/period and the day provided

See more:

SQL-Server-2008R2

Need to generate a new date with the Day given and the current month and current year given, such that with the period specified the new date will be generated using the date function


SET JDAY = 14

SET JMONTH = 11

SET JYEAR = 2014


Need to generate a new date with a certain number of months from the above months=11 and year=2014



1. Period or Months =15 from the above while maintaining the day =14

using

SET @FDATE = DATEADD(DAY,@JDAY-1,DATEADD(MONTH,@CCMTH-1,DATEADD(YEAR,@CCYR-1900,0)))


How do you accomplish it?

Expected Date is 14/02/2016 using the British Date Format

Thanks