topic calculate enddate in QlikView

calculate enddate

Mon, 20 Jun 2016 12:01:17 GMT

Hi,

I have a startdate (01.10.2015) and a useful life of 60 month (to Keep it simple).

Now I Need to calculate the Enddate (should be 30.09.2020).

I know this is an easy example but could you please tell me how to calculate this enddate in the script?

Thanks in advance.

Chris

Anonymous — Mon, 20 Jun 2016 12:04:35 GMT

try

addmonths(startdate,60) as enddate

avinashelite — Mon, 20 Jun 2016 12:06:24 GMT

if your start date is in proper date format then use the Addmonths() function

try like this

Addmonths(startdate,60) as Enddate

Mon, 20 Jun 2016 13:19:49 GMT

thanks alot.