Create a new date column by adding months to a date

[martin_hamilton]

Hi

am looking to create a new field via a load script which looks at 2 fields.

the 2 field in question are:

Date | #ofMonths

01/01/16 | 12

The new column will add the 12 months to the current date.

i can do this in an expression in a KPI object but want to add in the load as a new column i.e. =AddMonths([Contract Start Date], [Contract Term])

Any help appreciated

[sunny_talwar · Accepted solution]

Are you looking to create 12 new rows or just one column which would tell you the Contract End Date? If you just want a single Contract End Date, then may be this:

LOAD [Contract Start Date],

          [Contract Term],

          Date(AddMonths([Contract Start Date], [Contract Term])) as [Contract End Date]

FROM....

[martin_hamilton]

Hi

I figured this out myself in the end...

AddMonths([originaldate], [numberofmonths]) as [newdate]

[martin_hamilton]

Thanks Sunny, I saw your response after i figured it out myself. I did however forget to format as a date so have added this in.

cheers