Adding 1 Month to Date Calculation Column - 01-27-2012 , 12:25 AM
I'm trying 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]+ ???)
) ON [PRIMARY]
I have tried a couple of things with no luck.Please note that I am a complete novice to TSQL. Hope someone can help.
Re: Adding 1 Month to Date Calculation Column - 01-27-2012 , 01:25 AM
On 2012-01-27 07:25, Cory Jones wrote: