Bonus Pay Date Issue

[BeerLover1980]

Name	Bonus Contract Date	Bonus Pay Date
John Smith	3/8/2015	3/7/2017
John Doe	08/12/2014	8/11/2017
Suzy Que	01/31/2012	1/30/2017

So I'm working on a Bonus Tracking database. Everything is based off the Bonus Contract Date and has a term of 5 years. However, I need to track when each individual will be paid every year. As you can see in the example, John Smith signed his Bonus Contract on 3/8/15 and will be paid on March 7th of every subsequent year until 2020. Same thing with John Doe. He will be paid on every August 11th.



My question is:
1). How do I get the Bonus Pay date to Auto-fill to the correct and current payday for 2017
2). How do I write the code so it will update every year until the contract terminates.

[Micron]

The easiest would be to base it on the last bonus paid date rather than the contract start date. That might be the DMax of LastPaid date for a particular employee. Then you can use DateAdd to add one year to it (or there are other ways of adding a year). I would add this date as a record rather than over-writing the last paid date in case there are years when things are too lean to pay out bonuses. As for trapping the last year to be paid, that could be adding Date() to the start date and comparing that to the EndDate.