Create an end date by adding months

[pauldamen]

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

[rubenmarin · Accepted solution]

Hi Paul, You can use addmonths function:

AddMonths(Startdate, #Contractmonths)

[pauldamen]

Thanks!!

[CELAMBARASAN]

Try AddMonths Function

AddMonths(Startdate, #Contractmonths)

[crusader_]

Hi Paul,

Try AddMonths() function.

AddMonths(Startdate,#Contractmonths)

Hope this helps.

Andrei