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.
addmonths(startdate,60) as enddate
if your start date is in proper date format then use the Addmonths() function
try like this
Addmonths(startdate,60) as Enddate
Retrieving data ...