Display repeated group by date

Need help
1

Hi,

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,

Olivier

2

This topic was automatically closed after 70 days. New replies are no longer allowed.