Adding 1 Month to Date Calculation Column

• CoryJ72

  SSC Enthusiast

  Points: 110

  More actions

  January 26, 2012 at 11:52 pm

  #251997

  I'm trying to create a calculated column to add 1 month to a date from another column.

  CREATE TABLE [dbo].[test_table_date](

  [date1] [datetime] NOT NULL,

  [date2] AS ([date1]+(month ,1))

  ) ON [PRIMARY]

  Please note that I am a complete novice to TSQL. Hope someone can help.

  Cheers

  Cory

• Paul White

  SSC Guru

  Points: 150468

  More actions

  January 26, 2012 at 11:55 pm

  #1439150

  CREATE TABLE dbo.Test

  (

  Date1 date NOT NULL,

  Date2 AS DATEADD(MONTH, 1, Date1)

  );

  Paul White
  All articles available on SQL.kiwi
  @SQL_Kiwi

• CoryJ72

  SSC Enthusiast

  Points: 110

  More actions

  January 27, 2012 at 12:17 am

  #1439165

  Paul

  Worked well Thanks for the help. 😀