topic Re: Create a new date column by adding months to a date in QlikView

Create a new date column by adding months to a date

martin_hamilton — Wed, 10 Aug 2016 14:04:14 GMT

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

Re: Create a new date column by adding months to a date

sunny_talwar — Wed, 10 Aug 2016 14:27:58 GMT

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....

Re: Create a new date column by adding months to a date

martin_hamilton — Wed, 10 Aug 2016 14:28:11 GMT

I figured this out myself in the end...

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

Re: Create a new date column by adding months to a date

martin_hamilton — Wed, 10 Aug 2016 14:29:12 GMT

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