I have a start date. I need to get end date as 3 years from start date. How do I acheive this??
EndDate = AddYears(StartDate,3)
for EndDate try this..
YearStart(StartDate, 3) or YearEnd(StartDate, 3) //According to your need
Exactly if you need three years from startDate, then use
ex: AddYears(Today(),3) gives 11/26/2016
You need three years after startDate, then use
ex: YearEnd(Today(),3) gives 12/31/2016
Retrieving data ...