How to calculate next Anniversary date in OTBI
Summary
How to calculate next Anniversary date in OTBIContent
Hi All,
How to calculate next Anniversary date based on the employee hire date?
Example:
Number | Hire date | Next Anniversary Date |
1 | 06/15/2020 | 06/15/2021 |
2 | 10/31/2016 | 10/31/2021 |
3 | 02/01/2021 | 02/01/2022 |
Please help on this.
Regards,
Reddykrishna
0