 40 Points
Posted 3 years ago
Xavier Fan, Champion
 630 Points
Can you give an example? Say [Start Date] is 2/2/2016, and today is 2/19/2016. What is the 5year increment you're looking for?
 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?
Xavier Fan, Champion
 630 Points
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"?
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"?
Xavier Fan, Champion
 630 Points
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))
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))
Related Categories

Tables & fields
 7324 Conversations
 200 Followers