Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
Not applicable

calculate enddate

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

1 Solution

Accepted Solutions
Partner
Partner

Re: calculate enddate

try

addmonths(startdate,60) as enddate

3 Replies
Partner
Partner

Re: calculate enddate

try

addmonths(startdate,60) as enddate

Re: calculate enddate

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

try like this

Addmonths(startdate,60) as Enddate

Not applicable

Re: calculate enddate

thanks alot.