Pull birthdays in the next 90 days in OTBI.

Summary:

Hello all, How to pull birthdays in the next 90 days in OTBI. The logic I currently use is to pull birthdays that fall between WEEK OF YEAR ( CURRENT_DATE) and WEEK OF YEAR ( CURRENT _ DATE 12) . But this fails when there is a change in the year. Example when we moved from Dec 2023 to Jan 2024, I am getting birthdays only in Dec and not in Jan and Feb .  Any inputs are appreciated.

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):