I have a database with contracts and each has a date of signature. I need to display the next anniversary date for the next 5 contracts.
The anniversary date is the day/month of the date of signature but in the current year.
So if I say I’ve signed a contract the 1.1.2020 the next anniversary date is the 1.1.2023, but if I have a contract signed the 3.15.2020, the next anniversary date is the 3.15.2022.
Do someone have an idea on how I can display the next 5 contracts ordered by their next anniversary dates?
Thanks for you help,