Trying to find the date every 5 years from a start date. I have (AdjustYear([Start Date], 5)). How do I find the 5 year increment from the Start Date but after Today?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
Photo of Hao

Hao

  • 40 Points

Posted 3 years ago

  • 0
  • 1
Photo of Xavier Fan

Xavier Fan, Champion

  • 410 Points 250 badge 2x thumb
Can you give an example?  Say [Start Date] is 2/2/2016, and today is 2/19/2016.  What is the 5-year increment you're looking for?
Photo of Hao

Hao

  • 40 Points
Start date is 1990. 5 year date will be 1995. Every 5 years you get a bonus. When is the next bonus year from today 2/19/2016. Does that make sense?
Photo of Xavier Fan

Xavier Fan, Champion

  • 410 Points 250 badge 2x thumb
Does the Day and Month of [Start Date] matter?  Or do you care about just the Year?  

Say the [Start Date] is 2/1/1990.  Then the next bonus year after today would be 2/1/2020.

Are you looking to get back "2/1/2020" as the result?  Or just "2020"?
Photo of Hao

Hao

  • 40 Points
month, day and year. Thanks.
Photo of Xavier Fan

Xavier Fan, Champion

  • 410 Points 250 badge 2x thumb
Try this:

Create a Formula Date field called [Bonus Date], with the following formula:

var Number BonusYearIncrement = 5;

var Number YearsofEmployment = ToDays(Today() - [Start Date]) / 365;

var Number YearsToNextBonus = Ceil($YearsofEmployment, $BonusYearIncrement);



(AdjustYear([Start Date], $YearsToNextBonus))
Photo of Hao

Hao

  • 40 Points
Thanks Very Much!
Photo of Xavier Fan

Xavier Fan, Champion

  • 410 Points 250 badge 2x thumb
You're welcome!