Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
try
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
thanks alot.