Restricting Benefit Options by Enrollment Window – Benefits Eligibility Formula Help

Hi everyone,

I’m working on an Annual Leave Purchase plan where employees can buy extra annual leave days during two specific enrollment windows each year:

• 1–28/29 February: Up to 10 days, recovered over 12 months
• 1–31 July: Up to 5 days, recovered over 6 months

I want to ensure that only the relevant Option appears to employees depending on the current date i.e., the 12-month option should only be visible in February, and the 6-month option only in July.

I’ve written a simple Eligibility fast formula using TO_CHAR(EFFECTIVE_DATE, 'MMDD') logic, like this:

DEFAULT FOR EFFECTIVE_DATE IS SYSDATE

ELIGIBLE = 'N'