Adding date and interger values

• Russell Barrick

  SSC Rookie

  Points: 30

  More actions

  August 15, 2007 at 11:37 am

  #373276

  I'm trying to make a field called "maturity date" which gives the date that a contract my company has written will be fully matured. The way to calculate this is to add the number of terms(months) to the first payment date. Is it possible to add say 24 months to the month field of the first payment date?

• Sql Junkie-204042

  Hall of Fame

  Points: 3874

  More actions

  August 15, 2007 at 11:41 am

  #727138

  Look up DATEADD function in BOL (Books Online)

  DECLARE @PayDate datetime

  SET

  @PayDate = '2007-01-01'

  SELECT

  DATEADD(MONTH, 24,@PayDate)

• Russell Barrick

  SSC Rookie

  Points: 30

  More actions

  August 15, 2007 at 12:28 pm

  #727147

  Using the MSDN article, that doesnt seem to be working. Check out my expression:

  =DateAdd (Month, Fields!CONTRACT_TERM.Value, Fields!FIRST_PAY_DATE.Value)

  Do you see anything I could be doing wrong?

• jvElecenter

  SSCarpal Tunnel

  Points: 4502

  More actions

  August 16, 2007 at 6:41 am

  #727306

  Russel

   

  I used example from sqljunkie myself and it works just fine

   

  Is yr dateformet set wel ?

  Use the set dateformat function otherwise, e.g.  set dateformat mdy before yr statement.

  Good luck

  
  JV

• Russell Barrick

  SSC Rookie

  Points: 30

  More actions

  August 16, 2007 at 7:59 am

  #727330

  I ended up having to add something else to it. This is how it worked for me.

  =DateAdd (DateInterval.Month, Fields!CONTRACT_TERM.Value, Fields!FIRST_PAY_DATE.Value)

  That expression adds the number of months contained in CONTRACT_TERM to the date contained in FIRST_PAY_DATE. Thanks for your help guys!