Dates

[#1]

I have a start date. I need to get end date as 3 years from start date. How do I acheive this??

[Anonymous · Accepted solution]

EndDate = AddYears(StartDate,3)

[#3]

hi ,

for EndDate try this..

     YearStart(StartDate, 3)   or  YearEnd(StartDate, 3)      //According to your need

Regards

Ashutosh

[MayilVahanan]

Hi

Exactly if you  need three years from startDate, then use

AddYears(StartDate,3)

ex: AddYears(Today(),3) gives 11/26/2016

or

You need three years after startDate, then use

YearEnd(StartDate,3)

ex: YearEnd(Today(),3) gives 12/31/2016

[#5]

thank you..