topic Re: Create an end date by adding months in QlikView

Create an end date by adding months

pauldamen — Fri, 26 Sep 2014 07:05:13 GMT

All,

I have a start date for contracts which looks like: day-month-year( ie 25-9-2014). I have another field which says the number of months the contract will last (ie 2). What I need is to create an end date in this example: 25-9-2014 + 2 months = 25-11-2014

If I make a calculation like: Date(Startdate) + #Contractmonths, it will add up 2 days instead of 2 months. I tried different formulas but I can't add up the number for months it will only do the days.

Hope you guys can help.

Regards,

Paul

Re: Create an end date by adding months

rubenmarin — Fri, 26 Sep 2014 07:08:01 GMT

Hi Paul, You can use addmonths function:

AddMonths(Startdate, #Contractmonths)

Re: Create an end date by adding months

pauldamen — Fri, 26 Sep 2014 07:09:37 GMT

Thanks!!

Re: Create an end date by adding months

CELAMBARASAN — Fri, 26 Sep 2014 07:09:52 GMT

Try AddMonths Function

AddMonths(Startdate, #Contractmonths)

Re: Create an end date by adding months

crusader_ — Fri, 26 Sep 2014 07:11:45 GMT

Hi Paul,

Try AddMonths() function.

AddMonths(Startdate,#Contractmonths)

Hope this helps.

Andrei