calculate enddate

[#1]

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 · Accepted solution]

try

addmonths(startdate,60) as enddate

[avinashelite]

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

try like this

Addmonths(startdate,60) as Enddate

[#4]

thanks alot.